Column | Data Type | N | Description |
RECORD_NUMBER | integer | n | unique identifier for this record of metadata |
CONSTRAINT_CATALOG | identifier | n | constraint catalog |
CONSTRAINT_SCHEMA | identifier | n | constraint schema |
CONSTRAINT_NAME | identifier | n | constraint name |
TABLE_CATALOG | identifier | n | table catalog |
TABLE_SCHEMA | identifier | n | table schema |
TABLE_NAME | identifier | n | table name |
CONSTRAINT_TYPE | enumeration | n | NOT NULL or UNIQUE or PRIMARY KEY or FOREIGN KEY |
IS_DEFERABLE | yes_no | n | currently always 'N' |
INITIALLY_DEFERRED | yes_no | n | currently always 'N' |
SHORT_NAME | char(2) | y | Internal Adabas Identification of the constraint |