| 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
|
|
 외래값 탐색
|
| CHECKSUM |
bigint(21)
|
|
|
|
| CREATE_OPTIONS |
varchar(256)
|
utf8_general_ci
|
|
|
| TABLE_COMMENT |
text
|
utf8_general_ci
|
|
|
