Hi, > how can i get all the foreign keys from a database? i used SHOW INNODB > STATUS; but i get an unknown error!
You can only get them on a per-table basis with a SHOW CREATE TABLE <tablename> statement. 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]