You can use the standard MySQL commands to obtain information about a table.
SHOW [FULL] COLUMNS FROM tbl_name [FROM db_name] [LIKE 'pattern'];
For more information, see SHOW COLUMNS Syntax in the MySQL 5.x Reference Manual.
Utilization of the FULL option will provide an estimate of the compression for each column.
SHOW CREATE TABLE tbl_name;
For more information, see SHOW CREATE TABLE Syntax in the MySQL 5.x Reference Manual.
SHOW TABLE STATUS [FROM db_name] [LIKE 'pattern'];
For more information, see SHOW TABLE STATUS Syntax in the MySQL 5.x Reference Manual.
WebFOCUS |