List:General Discussion« Previous MessageNext Message »
From:Michael Seele Date:August 17 2004 11:06am
Subject:Re: SHOW foreign keys
View as plain text  
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 

Thread
SHOW foreign keysMichael Seele17 Aug
  • Re: SHOW foreign keysMartijn Tonies17 Aug
    • Re: SHOW foreign keysMichael Seele17 Aug
  • Re: SHOW foreign keysMartijn Tonies17 Aug
  • Multiple MySQL Versions on Same Linux BoxLou Olsten17 Aug
    • Re: Multiple MySQL Versions on Same Linux BoxV. M. Brasseur17 Aug