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 | |||
COLUMN_NAME | varchar(64) | No | |||
ORDINAL_POSITION | bigint(21) | No | 0 | ||
COLUMN_DEFAULT | longtext | Yes | NULL | ||
IS_NULLABLE | varchar(3) | No | |||
DATA_TYPE | varchar(64) | No | |||
CHARACTER_MAXIMUM_LENGTH | bigint(21) | Yes | NULL | ||
CHARACTER_OCTET_LENGTH | bigint(21) | Yes | NULL | ||
NUMERIC_PRECISION | bigint(21) | Yes | NULL | ||
NUMERIC_SCALE | bigint(21) | Yes | NULL | ||
DATETIME_PRECISION | bigint(21) | Yes | NULL | ||
CHARACTER_SET_NAME | varchar(32) | Yes | NULL | CHARACTER_SETS -> CHARACTER_SET_NAME | |
COLLATION_NAME | varchar(32) | Yes | NULL | COLLATIONS -> COLLATION_NAME | |
COLUMN_TYPE | longtext | No | |||
COLUMN_KEY | varchar(3) | No | |||
EXTRA | varchar(30) | No | |||
PRIVILEGES | varchar(80) | No | |||
COLUMN_COMMENT | varchar(1024) | No |