List:General Discussion« Previous MessageNext Message »
From:Martijn Tonies Date:January 27 2004 5:36pm
Subject:Re: FKs in InnoDB
View as plain text  
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

Thread
FKs in InnoDBDon Vu27 Jan
RE: FKs in InnoDBMechain Marc27 Jan
  • Re: FKs in InnoDBMartijn Tonies27 Jan
RE: FKs in InnoDBDon Vu27 Jan