List:General Discussion« Previous MessageNext Message »
From:Martijn Tonies Date:November 26 2004 4:31pm
Subject:Re: How to retrieve constraints and links from MySQL tables?
View as plain text  
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

Thread
How to retrieve constraints and links from MySQL tables?Varakorn Ungvichian26 Nov
  • Re: How to retrieve constraints and links from MySQL tables?Martijn Tonies26 Nov
    • Re: How to retrieve constraints and links from MySQL tables?Varakorn Ungvichian28 Nov
    • Re: How to retrieve constraints and links from MySQL tables?Varakorn Ungvichian28 Nov
      • Re: How to retrieve constraints and links from MySQL tables?Martijn Tonies28 Nov
      • Re: How to retrieve constraints and links from MySQL tables?Michael Stassen28 Nov
        • Re: How to retrieve constraints and links from MySQL tables?Varakorn Ungvichian29 Nov
          • Re: How to retrieve constraints and links from MySQL tables?Michael Stassen29 Nov
RE: How to retrieve constraints and links from MySQL tables?Mechain Marc26 Nov
  • Re: How to retrieve constraints and links from MySQL tables?Martijn Tonies26 Nov