The REFERENTIAL_CONSTRAINTS view contains one row for each referential
constraint. The following table describes the columns in the
view:
Table 154. REFERENTIAL_CONSTRAINTS view
Column Name | Data Type | Description |
---|---|---|
CONSTRAINT_CATALOG | VARCHAR(128) | Relational database name |
CONSTRAINT_SCHEMA | VARCHAR(128) | Name of the schema containing the constraint. |
CONSTRAINT_NAME | VARCHAR(128) | Name of the constraint. |
UNIQUE_CONSTRAINT_CATALOG | VARCHAR(128) | Relational database name containing the unique constraint referenced by the referential constraint. |
UNIQUE_CONSTRAINT_SCHEMA | VARCHAR(128) | Name of the SQL schema containing the unique constraint referenced by the referential constraint. |
UNIQUE_CONSTRAINT_NAME | VARCHAR(128) | Name of the unique constraint referenced by the referential constraint. |
MATCH_OPTION | VARCHAR(7) | Reserved. Contains 'NONE'. |
UPDATE_RULE | VARCHAR(11) | Update Rule.
|
DELETE_RULE | VARCHAR(11) | Delete Rule
|
(C) Copyright IBM Corporation 1992, 2005. All Rights Reserved.