Column name
|
Data type
|
Description
|
| CONSTRAINT
_CATALOG |
VARCHAR(128) |
The name of the catalog containing the referential constraint. |
| CONSTRAINT_SCHEMA |
VARCHAR(128) |
The name of the schema containing the referential constraint. |
| CONSTRAINT_NAME |
VARCHAR(128) |
The name of the referential constraint. |
| UNIQUE_CONSTRAINT
_CATALOG |
VARCHAR(128) |
The name of the catalog containing the unique constraint being referenced. |
| UNIQUE_CONSTRAINT
_SCHEMA |
VARCHAR(128) |
The name of the schema containing the unique constraint being referenced |
| UNIQUE_CONSTRAINT
_NAME |
VARCHAR(128) |
The name of the unique constraint being referenced. |
| MATCH_OPTION |
VARCHAR(20) |
One of:
NONE
PARTIAL
FULL. |
| UPDATE_RULE |
VARCHAR(20) |
One of:
CASCADE
SET NULL
SET DEFAULT
NO ACTION. |
| DELETE_RULE |
VARCHAR(20) |
One of:
CASCADE
SET NULL
SET DEFAULT
NO ACTION. |
