Column | Type | Null | Default | Links to | Comments |
---|---|---|---|---|---|
TABLE_CATALOG | varchar(512) | No | |||
TABLE_SCHEMA | varchar(64) | No | SCHEMATA -> SCHEMA_NAME | ||
TABLE_NAME | varchar(64) | No | |||
TABLE_TYPE | varchar(64) | No | |||
ENGINE | varchar(64) | Yes | NULL | ENGINES -> ENGINE | |
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(32) | Yes | NULL | COLLATIONS -> COLLATION_NAME | |
CHECKSUM | bigint(21) | Yes | NULL | ||
CREATE_OPTIONS | varchar(255) | Yes | NULL | ||
TABLE_COMMENT | varchar(2048) | No |