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 | |||
NON_UNIQUE | bigint(1) | No | 0 | ||
INDEX_SCHEMA | varchar(64) | No | SCHEMATA -> SCHEMA_NAME | ||
INDEX_NAME | varchar(64) | No | |||
SEQ_IN_INDEX | bigint(2) | No | 0 | ||
COLUMN_NAME | varchar(64) | No | |||
COLLATION | varchar(1) | Yes | NULL | ||
CARDINALITY | bigint(21) | Yes | NULL | ||
SUB_PART | bigint(3) | Yes | NULL | ||
PACKED | varchar(10) | Yes | NULL | ||
NULLABLE | varchar(3) | No | |||
INDEX_TYPE | varchar(16) | No | |||
COMMENT | varchar(16) | Yes | NULL | ||
INDEX_COMMENT | varchar(1024) | No |