From: Martijn Tonies
Date: January 27 2004 5:36pm
Subject: Re: FKs in InnoDB
List-Archive: http://lists.mysql.com/mysql/158483
Message-Id: <047501c3e4fc$1e5738b0$0e02a8c0@martijn>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

Hi,

> SHOW TABLE STATUS
>
> In the "Comment" Column you have the definition of the foreign keys.

I have to disagree here.

The only reliable way to get FK info, is to use
SHOW CREATE TABLE tablename

With regards,

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