TABLES

mmt
FieldTypeNullKeyDefaultExtra
TABLE_CATALOG varchar(64) NO
TABLE_SCHEMA varchar(64) NO
TABLE_NAME varchar(64) NO
TABLE_TYPE enum('BASE TABLE','VIEW','SYSTEM VIEW') NO
ENGINE varchar(64) YES
VERSION int(2) YES
ROW_FORMAT enum('Fixed','Dynamic','Compressed','Redundant','Compact','Paged') YES
TABLE_ROWS bigint(21) unsigned YES
AVG_ROW_LENGTH bigint(21) unsigned YES
DATA_LENGTH bigint(21) unsigned YES
MAX_DATA_LENGTH bigint(21) unsigned YES
INDEX_LENGTH bigint(21) unsigned YES
DATA_FREE bigint(21) unsigned YES
AUTO_INCREMENT bigint(21) unsigned YES
CREATE_TIME timestamp NO CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP
UPDATE_TIME datetime YES
CHECK_TIME datetime YES
TABLE_COLLATION varchar(64) YES
CHECKSUM bigint(21) YES
CREATE_OPTIONS varchar(256) YES
TABLE_COMMENT varchar(256) YES
[ START ][ Connect ] [ create table form ]

MySQL Nippon Association