Mega Code Archive

 

Categories / MySQL Tutorial / Data Dictionary

 

The INFORMATION_SCHEMA TABLES Table

The TABLES table provides information about tables in databases. mysql> desc INFORMATION_SCHEMA.TABLES; +-----------------+--------------+------+-----+---------+-------+ | Field           | Type         | Null | Key | Default | Extra | +-----------------+--------------+------+-----+---------+-------+ | TABLE_CATALOG   | varchar(512) | YES  |     | NULL    |       | | TABLE_SCHEMA    | varchar(64)  | NO   |     |         |       | | TABLE_NAME      | varchar(64)  | NO   |     |         |       | | TABLE_TYPE      | varchar(64)  | NO   |     |         |       | | ENGINE          | varchar(64)  | YES  |     | NULL    |       | | VERSION         | bigint(21)   | YES  |     | NULL    |       | | ROW_FORMAT      | varchar(10)  | YES  |     | NULL    |       | | TABLE_ROWS      | bigint(21)   | YES  |     | NULL    |       | | AVG_ROW_LENGTH  | bigint(21)   | YES  |     | NULL    |       | | DATA_LENGTH     | bigint(21)   | YES  |     | NULL    |       | | MAX_DATA_LENGTH | bigint(21)   | YES  |     | NULL    |       | | INDEX_LENGTH    | bigint(21)   | YES  |     | NULL    |       | | DATA_FREE       | bigint(21)   | YES  |     | NULL    |       | | AUTO_INCREMENT  | bigint(21)   | YES  |     | NULL    |       | | CREATE_TIME     | datetime     | YES  |     | NULL    |       | | UPDATE_TIME     | datetime     | YES  |     | NULL    |       | | CHECK_TIME      | datetime     | YES  |     | NULL    |       | | TABLE_COLLATION | varchar(64)  | YES  |     | NULL    |       | | CHECKSUM        | bigint(21)   | YES  |     | NULL    |       | | CREATE_OPTIONS  | varchar(255) | YES  |     | NULL    |       | | TABLE_COMMENT   | varchar(80)  | NO   |     |         |       | +-----------------+--------------+------+-----+---------+-------+ 21 rows in set (0.01 sec)