|
TABLE_CATALOG
|
varchar(64)
|
utf8mb3_bin
|
|
|
|
TABLE_SCHEMA
|
varchar(64)
|
utf8mb3_bin
|
|
|
|
TABLE_NAME
|
varchar(64)
|
utf8mb3_bin
|
|
|
|
TABLE_TYPE
|
enum('BASE TABLE', 'VIEW', 'SYSTEM VIEW')
|
utf8mb3_bin
|
|
|
|
ENGINE
|
varchar(64)
|
utf8mb3_general_ci
|
|
|
|
VERSION
|
int
|
|
|
|
|
ROW_FORMAT
|
enum('Fixed', 'Dynamic', 'Compressed', 'Redundant', 'Compact', 'Paged')
|
utf8mb3_bin
|
|
|
|
TABLE_ROWS
|
bigint
|
|
|
|
|
AVG_ROW_LENGTH
|
bigint
|
|
|
|
|
DATA_LENGTH
|
bigint
|
|
|
|
|
MAX_DATA_LENGTH
|
bigint
|
|
|
|
|
INDEX_LENGTH
|
bigint
|
|
|
|
|
DATA_FREE
|
bigint
|
|
|
|
|
AUTO_INCREMENT
|
bigint
|
|
|
|
|
CREATE_TIME
|
timestamp
|
|
|
|
|
UPDATE_TIME
|
datetime
|
|
|
|
|
CHECK_TIME
|
datetime
|
|
|
|
|
TABLE_COLLATION
|
varchar(64)
|
utf8mb3_general_ci
|
|
 Visualizar valores estrangeiros
|
|
CHECKSUM
|
bigint
|
|
|
|
|
CREATE_OPTIONS
|
varchar(256)
|
utf8mb3_general_ci
|
|
|
|
TABLE_COMMENT
|
text
|
utf8mb3_general_ci
|
|
|
