Table_Constraints View
Describes the table constraints.
This view is part of the ANSI SQL-2 standard Information Schema.

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