From: Martijn Tonies
Date: November 26 2004 4:31pm
Subject: Re: How to retrieve constraints and links from MySQL tables?
List-Archive: http://lists.mysql.com/mysql/176443
Message-Id: <005a01c4d3d5$59229570$0a02a8c0@martijn>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

Hello,

> You can use:
>
> show create table employee;
>
> or
>
> show table status like 'employee';
> in the column "comment" you have the information you are looking for.

I don't think "comment" works properly - it's too small if you have
multiple foreign key constraints.

With regards,

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