From: Martijn Tonies
Date: August 25 2004 5:48pm
Subject: Re: How do I find out a table's constraints ?
List-Archive: http://lists.mysql.com/mysql/171535
Message-Id: <000601c48acb$ccd19d20$0a02a8c0@martijn>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit




> What command should I use to find out a table's constraints?

If you're talking about Foreign Key constraints, you
can have a look at them via the
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