Hi, > SHOW TABLE STATUS > > In the "Comment" Column you have the definition of the foreign keys.
I have to disagree here. The only reliable way to get FK info, is to use SHOW CREATE TABLE tablename 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]