From: Martijn Tonies
Date: August 17 2004 11:33am
Subject: Re: SHOW foreign keys
List-Archive: http://lists.mysql.com/mysql/171077
Message-Id: <038301c4844e$06aa0de0$0a02a8c0@martijn>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit


> 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