>From: "Naresh Sadhnani" > >You could also try > >SHOW KEYS FROM <dbname>.<tablename> > >Should work.
According to the documentation, this is an alternative for SHOW INDEX FROM <tablename> A quick try gave me no results for FKs, only PKs and indices. 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]
