List of Constraints from MySQL Database

by

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"

More Related Contents:

  1. Unique constraint that allows empty values in MySQL
  2. Cakephp Career Database Design
  3. How to store multiple options in a single table?
  4. How to pivot a MySQL entity-attribute-value schema
  5. Implementing Comments and Likes in database
  6. MySQL: multiple tables or one table with many columns? [closed]
  7. Is it possible to query a tree structure table in MySQL in a single query, to any depth?
  8. Auto Generate Database Diagram MySQL [closed]
  9. How do I add a custom CHECK constraint on a MySQL table?
  10. Storing SHA1 hash values in MySQL
  11. MySQL ENUM type vs join tables
  12. How to truncate a foreign key constrained table?
  13. Relational database design multiple user types
  14. Can a MySQL trigger simulate a CHECK constraint? [duplicate]
  15. A constraint to prevent the insert of an empty string in MySQL
  16. MySQL Removing Some Foreign keys
  17. Facebook like notifications tracking (DB Design)
  18. How to design a multi tenant mysql database
  19. How to add not null constraint to existing column in MySQL
  20. DOs and DONTs for Indexes [closed]
  21. MySQL triggers cannot update rows in same table the trigger is assigned to. Suggested workaround?
  22. Difference between two table structure
  23. Proper database model for a user feedback system (an interesting case)
  24. Use Composite Primary Key as Foreign Key
  25. When to use a left outer join?
  26. MySQL distinction between e and é (e acute) – UNIQUE index
  27. MySQL and Check Constraints
  28. MySQL: how to do row-level security (like Oracle’s Virtual Private Database)?
  29. MySQL Relationships
  30. Inventory management with stock options

Leave a Comment