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 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.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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
