and how is a foreign key displayed? as KEY or FOREIGN KEY???
Martijn Tonies schrieb am 17.08.2004 12:24:
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
--
G & H Softwareentwicklung GmbH Tel.: +49(0)7451/53706-20
Robert-Bosch-Str. 23 Fax: +49(0)7451/53706-90
D-72160 Horb a.N. http://www.guh-software.de
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]