MySQL: List all Contraints on a Table
Sometimes it is useful to show all your constraints, you have set on a Table in your Database. To achive this, type the following statement SELECT DISTINCT(constraint_name) from information_schema.table_constraints where constraint_schema = “ order by constraint_name ASC; MySQL should return a list like this, depends on your constraints +————————+ | constraint_name | +————————+ | bugsnumk […]