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]
