Thanks, marc.
-Don
-----Original Message-----
From: Mechain Marc [mailto:Marc.Mechain@stripped]
Sent: Tuesday, January 27, 2004 12:23 PM
To: Don Vu; mysql@stripped
Subject: RE: FKs in InnoDB
SHOW TABLE STATUS
In the "Comment" Column you have the definition of the foreign keys.
Marc.
-----Message d'origine-----
De : Don Vu [mailto:dvu@stripped]
Envoyé : mardi 27 janvier 2004 17:48
À : mysql@stripped
Objet : FKs in InnoDB
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
