Describes the referential 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 |
|
UNIQUE_CONSTRAINT_CATALOG |
identifier |
n |
unique constraint catalog |
|
UNIQUE_CONSTRAINT_SCHEMA |
identifier |
n |
unique constraint schema |
|
UNIQUE_CONSTRAINT_NAME |
identifier |
n |
unique constraint name |
|
MATCH_OPTION |
enumeration |
n |
match option: NONE or PARTIAL or FULL |
|
UPDATE_RULE |
enumeration |
n |
update rule: NO ACTION or CASCADE or SET NULL or SET DEFAULT |
|
DELETE_RULE |
enumeration |
n |
delete rule: NO ACTION or CASCADE or SET NULL or SET DEFAULT |
|
IS_CLUSTERING |
yes_no |
n |
Y if the referential constraint is implied by a table cluster |