List:General Discussion« Previous MessageNext Message »
From:Don Vu Date:January 27 2004 6:38pm
Subject:RE: FKs in InnoDB
View as plain text  
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
 
Thread
FKs in InnoDBDon Vu27 Jan
RE: FKs in InnoDBMechain Marc27 Jan
  • Re: FKs in InnoDBMartijn Tonies27 Jan
RE: FKs in InnoDBDon Vu27 Jan