The SYSREFCST view contains one row for each foreign key in the SQL schema. The following table describes the columns in the SYSREFCST view:
Column Name | System Column Name | Data Type | Description |
---|---|---|---|
CONSTRAINT_SCHEMA | CDBNAME | VARCHAR(128) | Name of the schema containing the constraint. |
CONSTRAINT_NAME | RELNAME | VARCHAR(128) | Name of the constraint. |
UNIQUE_CONSTRAINT_SCHEMA | UNQDBNAME | VARCHAR(128) | Name of the SQL schema containing the unique constraint referenced by the referential constraint. |
UNIQUE_CONSTRAINT_NAME | UNQNAME | VARCHAR(128) | Name of the unique constraint referenced by the referential constraint. |
MATCH_OPTION | MATCH | VARCHAR(7) | Match option. Will always be NONE. |
UPDATE_RULE | UPDATE | VARCHAR(11) | Update Rule.
|
DELETE_RULE | DELETE | VARCHAR(11) | Delete Rule
|
COLUMN_COUNT | COLCOUNT | INTEGER | Number of columns in the foreign key. |
(C) Copyright IBM Corporation 1992, 2006. All Rights Reserved.