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]



Reply via email to