> and how is a foreign key displayed? as KEY or FOREIGN KEY??? No, not at all - it's shown in the CREATE TABLE statement - have a try at it yourself.
You need to parse the info from the text. You can also not create a FK by name, InnoDB will assign a name to it. Changing an attribute on your constraint will rename it. 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]