Column | Type | Null | Default | Links to | Comments |
---|---|---|---|---|---|
CONSTRAINT_CATALOG | varchar(512) | No | |||
CONSTRAINT_SCHEMA | varchar(64) | No | SCHEMATA -> SCHEMA_NAME | ||
CONSTRAINT_NAME | varchar(64) | No | |||
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(10) | No | 0 | ||
POSITION_IN_UNIQUE_CONSTRAINT | bigint(10) | Yes | NULL | ||
REFERENCED_TABLE_SCHEMA | varchar(64) | Yes | NULL | SCHEMATA -> SCHEMA_NAME | |
REFERENCED_TABLE_NAME | varchar(64) | Yes | NULL | ||
REFERENCED_COLUMN_NAME | varchar(64) | Yes | NULL |