You could also try
SHOW KEYS FROM <dbname>.<tablename>
From: Martijn Tonies [mailto:m.tonies@stripped]
Sent: 06 August 2004 14:06
Subject: Re: Where are the Foreign Keys?
> as far as i know, there is only 1 way to extract the foreign key
from a table: "show create table <tablename>".
> Are there any others?
The "comments" column in SHOW TABLE STATUS is supposed
to list the FKs as well. A rather silly way of doing things, IMO, cause
you can't use the "comments" yourself anymore. Besides, the "comments"
field is waaay too short for a larger number of FKs.
So, as far as I know, SHOW CREATE TABLE is the only way.
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS
SQL Server. Upscene Productions http://www.upscene.com
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom
they are addressed.
If you have received this email in error please notify the
originator of the message. This footer also confirms that this
email message has been scanned for the presence of computer viruses.
Any views expressed in this message are those of the individual
sender, except where the sender specifies and with authority,
states them to be the views of DA Group.