From: Martijn Tonies
Date: August 6 2004 1:05pm
Subject: Re: Where are the Foreign Keys?
List-Archive: http://lists.mysql.com/mysql/170443
Message-Id: <03ef01c47bb6$0cc9c2b0$0a02a8c0@martijn>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

Hi Ralf,

> as far as i know, there is only 1 way to extract the foreign key relations
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.

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com