Re: How to query MySQL to get a table definition (column defs, constraint defs (pk, fk, uni...))

[Ramalingam Chelliah]

Hi ,
Aren't you satisfied with 'DESCRIBE' ?

mysql > DESC myTable;

It lists your table's structure in a table from...

Otherwise you can use 'SHOW CREATE TABLE <tablename>' to look
into the CREATE statement used to CREATE the table and the table type

mysql> SHOW CREATE TABLE myTable;


Try these too
mysql> SHOW FULL COLUMNS FROM myTable;

and 'SHOW INDEX'

Check this page

http://dev.mysql.com/doc/mysql/en/SHOW.html


Hope this helps...

Regards,
Ram.





We Learn the Most When we have to Invent