List:General Discussion« Previous MessageNext Message »
From:Martijn Tonies Date:August 17 2004 11:33am
Subject:Re: SHOW foreign keys
View as plain text  
> and how is a foreign key displayed? as KEY or FOREIGN KEY???

No, not at all - it's shown in the CREATE TABLE statement - have
a try at it yourself.

You need to parse the info from the text. You can also not create a
FK by name, InnoDB will assign a name to it. Changing an attribute
on your constraint will rename it.

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com

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