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)
Name (required)
email (will not be published) (required)
Website
