Tuesday, March 6, 2012

Query to Show MySQL table definition structure

mysql> DESC tableName;
mysql> SHOW CREATE TABLE tableName;
mysql> SHOW FULL COLUMNS FROM tableName;
mysql> SHOW INDEX FROM tableName;

No comments: