Hi Ralf, > as far as i know, there is only 1 way to extract the foreign key relations from a table: "show create table <tablename>". > Are there any others?
The "comments" column in SHOW TABLE STATUS is supposed to list the FKs as well. A rather silly way of doing things, IMO, cause you can't use the "comments" yourself anymore. Besides, the "comments" field is waaay too short for a larger number of FKs. So, as far as I know, SHOW CREATE TABLE is the only way. With regards, Martijn Tonies Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL Server. Upscene Productions http://www.upscene.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
