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 |