Hello, > You can use: > > show create table employee; > > or > > show table status like 'employee'; > in the column "comment" you have the information you are looking for.
I don't think "comment" works properly - it's too small if you have multiple foreign key constraints. 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]
