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
