Posted by lorento on 11/14/06 06:51

Use command:

SHOW CREATE TABLE table_name

Note, foreign key available only in innodb. If you use myisam there is
no foreign key.

--
http://www.mastervb.net
http://www.theukmap.com

John Smit wrote:
> Hello all,
>
> I know of the SHOW FIELDS... and SHOW KEYS... statements. I see there is no
> SHOW CONSTRAINTS statement.
> Is there an other way to find out which foreign keys a table has
> implemented?
>
> Thanks in advance Rob

[Back to original message]