How do I find out a table's constraints ?

2004-08-25 Thread Nestor Florez
What command should I use to find out a table's constraints? Thanks, :-) Néstor Alberto Flórez Torres -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: How do I find out a table's constraints ?

2004-08-25 Thread Martijn Tonies
What command should I use to find out a table's constraints? If you're talking about Foreign Key constraints, you can have a look at them via the SHOW CREATE TABLE tablename statement. With regards, Martijn Tonies Database Workbench - developer tool for InterBase, Firebird, MySQL MS SQL