Show constraints on tables command

by

I use

SHOW CREATE TABLE mytable;

This shows you the SQL statement necessary to receate mytable in its current form. You can see all the columns and their types (like DESC) but it also shows you constraint information (and table type, charset, etc.).

More Related Contents:

  1. MySQL Creating tables with Foreign Keys giving errno: 150
  2. MySQL Error 1215: Cannot add foreign key constraint
  3. Mysql error 1452 – Cannot add or update a child row: a foreign key constraint fails
  4. MySQL foreign key constraints, cascade delete
  5. How do I see all foreign keys to a table or column?
  6. MySQL Cannot Add Foreign Key Constraint
  7. How to find all tables that have foreign keys that reference particular table.column and have values for those foreign keys?
  8. Required to join 2 tables with their FKs in a 3rd table
  9. Error Code: 1005. Can’t create table ‘…’ (errno: 150)
  10. Basics of Foreign Keys in MySQL?
  11. Can a foreign key reference a non-unique index?
  12. MySQL – Conditional Foreign Key Constraints
  13. How do I use on delete cascade in mysql?
  14. Add Foreign Key to existing table
  15. How to change the foreign key referential action? (behavior)
  16. How to create relationships in MySQL
  17. How to truncate a foreign key constrained table?
  18. MySQL InnoDB foreign key between different databases
  19. MySQL Removing Some Foreign keys
  20. Force InnoDB to recheck foreign keys on a table/tables?
  21. Is it possible to reference one column as multiple foreign keys?
  22. How to insert values in table with foreign key using MySQL?
  23. MySQL foreign key to allow NULL?
  24. MySQL Errno 150
  25. How to remove constraints from my MySQL table?
  26. Foreign key constraints: When to use ON UPDATE and ON DELETE
  27. MySQL “ERROR 1005 (HY000): Can’t create table ‘foo.#sql-12c_4’ (errno: 150)”
  28. MySQL errorno 121
  29. “General error: 1005 Can’t create table” Using Laravel Schema Build and Foreign Keys
  30. MySQL Relationships

Leave a Comment