List of Constraints from MySQL Database

Question

How do I get a list of all constraints from a particular database?

Answer 1

Use the information_schema.table_constraints table to get the names of the constraints defined on each table:

select * from information_schema.table_constraints where constraint_schema = 'YOUR_DB' 

Use the information_schema.key_column_usage table to get the fields in each one of those constraints:

select * from information_schema.key_column_usage where constraint_schema = 'YOUR_DB' 

If instead you are talking about foreign key constraints, use information_schema.referential_constraints:

select * from information_schema.referential_constraints where constraint_schema = 'YOUR_DB' 

Answer 2

Great answer by @Senseful.

I am presenting modified query for those who are only looking for list of constraint names (and not other details/columns):

SELECT DISTINCT(constraint_name)  FROM information_schema.table_constraints  WHERE constraint_schema = 'YOUR_DB'  ORDER BY constraint_name ASC;