Re: How to retrieve constraints and links from MySQL tables?

[Martijn Tonies]

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