(mysql.info) tables-table
Info Catalog
(mysql.info) schemata-table
(mysql.info) information-schema
(mysql.info) columns-table
20.2 The `INFORMATION_SCHEMA TABLES' Table
==========================================
The `TABLES' table provides information about tables in databases.
*`INFORMATION_SCHEMA' Name* *`SHOW' Name* *Remarks*
`TABLE_CATALOG' `NULL'
`TABLE_SCHEMA' `Table_'...
`TABLE_NAME' `Table_'...
`TABLE_TYPE'
`ENGINE' `Engine' MySQL extension
`VERSION' `Version' MySQL extension
`ROW_FORMAT' `Row_format' MySQL extension
`TABLE_ROWS' `Rows' MySQL extension
`AVG_ROW_LENGTH' `Avg_row_length' MySQL extension
`DATA_LENGTH' `Data_length' MySQL extension
`MAX_DATA_LENGTH' `Max_data_length' MySQL extension
`INDEX_LENGTH' `Index_length' MySQL extension
`DATA_FREE' `Data_free' MySQL extension
`AUTO_INCREMENT' `Auto_increment' MySQL extension
`CREATE_TIME' `Create_time' MySQL extension
`UPDATE_TIME' `Update_time' MySQL extension
`CHECK_TIME' `Check_time' MySQL extension
`TABLE_COLLATION' `Collation' MySQL extension
`CHECKSUM' `Checksum' MySQL extension
`CREATE_OPTIONS' `Create_options' MySQL extension
`TABLE_COMMENT' `Comment' MySQL extension
Notes:
* `TABLE_SCHEMA' and `TABLE_NAME' are a single field in a `SHOW'
display, for example `Table_in_db1'.
* `TABLE_TYPE' should be `BASE TABLE' or `VIEW'. If table is
temporary, then `TABLE_TYPE' = `TEMPORARY'. (There are no
temporary views, so this is not ambiguous.)
* The `TABLE_ROWS' column is `NULL' if the table is in the
`INFORMATION_SCHEMA' database. For `InnoDB' tables, the row count
is only a rough estimate used in SQL optimization.
* We have nothing for the table's default character set.
`TABLE_COLLATION' is close, because collation names begin with a
character set name.
The following statements are equivalent:
SELECT table_name FROM INFORMATION_SCHEMA.TABLES
[WHERE table_schema = 'DB_NAME']
[WHERE|AND table_name LIKE 'WILD']
SHOW TABLES
[FROM DB_NAME]
[LIKE 'WILD']
Info Catalog
(mysql.info) schemata-table
(mysql.info) information-schema
(mysql.info) columns-table
automatically generated byinfo2html