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