Field Name | Type | Length | Flags | ||
TABLE_CATALOG | VAR_STRING | 2048 | not_null | ||
TABLE_SCHEMA | VAR_STRING | 256 | not_null | ||
TABLE_NAME | VAR_STRING | 256 | not_null | ||
COLUMN_NAME | VAR_STRING | 256 | not_null | ||
ORDINAL_POSITION | LONGLONG | 21 | not_null | ||
COLUMN_DEFAULT | BLOB | 786384 | blob | ||
IS_NULLABLE | VAR_STRING | 12 | not_null | ||
DATA_TYPE | VAR_STRING | 256 | not_null | ||
CHARACTER_MAXIMUM_LENGTH | LONGLONG | 21 | |||
CHARACTER_OCTET_LENGTH | LONGLONG | 21 | |||
NUMERIC_PRECISION | LONGLONG | 21 | |||
NUMERIC_SCALE | LONGLONG | 21 | |||
DATETIME_PRECISION | LONGLONG | 21 | |||
CHARACTER_SET_NAME | VAR_STRING | 128 | |||
COLLATION_NAME | VAR_STRING | 128 | |||
COLUMN_TYPE | BLOB | 786420 | not_null, blob | ||
COLUMN_KEY | VAR_STRING | 12 | not_null | ||
EXTRA | VAR_STRING | 320 | not_null | ||
PRIVILEGES | VAR_STRING | 320 | not_null | ||
COLUMN_COMMENT | VAR_STRING | 4096 | not_null | ||
IS_GENERATED | VAR_STRING | 24 | not_null | ||
GENERATION_EXPRESSION | BLOB | 786384 | blob | ||
New Field |