Thanks, marc.
-Don
-Original Message-
From: Mechain Marc [mailto:[EMAIL PROTECTED]
Sent: Tuesday, January 27, 2004 12:23 PM
To: Don Vu; [EMAIL PROTECTED]
Subject: RE: FKs in InnoDB
SHOW TABLE STATUS
In the "Comment" Column you have the definition of the foreign k
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
SHOW TABLE STATUS
In the "Comment" Column you have the definition of the foreign keys.
Marc.
-Message d'origine-
De : Don Vu [mailto:[EMAIL PROTECTED]
Envoyé : mardi 27 janvier 2004 17:48
À : [EMAIL PROTECTED]
Objet : FKs in InnoDB
Hi,
I'm using MySQL 4.0.1
Hi,
I'm using MySQL 4.0.16 with InnoDB tables.
>From the command-line mysql console Is there an easy way to see all the
names of the foreign keys in my db? Basically I want to generate a file
that drops all the foreign keys currently in my db.
thanks,
Don