Re: FKs in InnoDB

[Martijn Tonies]

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