TABLE_CATALOG |
varchar(64)
|
utf8_bin
|
|
|
TABLE_SCHEMA |
varchar(64)
|
utf8_bin
|
|
|
TABLE_NAME |
varchar(64)
|
utf8_bin
|
|
|
TABLE_TYPE |
enum('BASE TABLE', 'VIEW', 'SYSTEM VIEW')
|
utf8_bin
|
|
|
ENGINE |
varchar(64)
|
utf8_general_ci
|
|
|
VERSION |
int(2)
|
|
|
|
ROW_FORMAT |
enum('Fixed', 'Dynamic', 'Compressed', 'Redundant', 'Compact', 'Paged')
|
utf8_bin
|
|
|
TABLE_ROWS |
bigint(21)
|
|
|
|
AVG_ROW_LENGTH |
bigint(21)
|
|
|
|
DATA_LENGTH |
bigint(21)
|
|
|
|
MAX_DATA_LENGTH |
bigint(21)
|
|
|
|
INDEX_LENGTH |
bigint(21)
|
|
|
|
DATA_FREE |
bigint(21)
|
|
|
|
AUTO_INCREMENT |
bigint(21)
|
|
|
|
CREATE_TIME |
timestamp
|
|
|
|
UPDATE_TIME |
datetime
|
|
|
|
CHECK_TIME |
datetime
|
|
|
|
TABLE_COLLATION |
varchar(64)
|
utf8_general_ci
|
|
Browse foreign values
|
CHECKSUM |
bigint(21)
|
|
|
|
CREATE_OPTIONS |
varchar(256)
|
utf8_general_ci
|
|
|
TABLE_COMMENT |
text
|
utf8_general_ci
|
|
|