SYSREFCST

The SYSREFCST view contains one row for each foreign key in the SQL schema. The following table describes the columns in the SYSREFCST view:

Table 128. 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.
  • NO ACTION
  • RESTRICT
DELETE_RULE DELETE VARCHAR(11) Delete Rule
  • NO ACTION
  • CASCADE
  • SET NULL
  • SET DEFAULT
  • RESTRICT
COLUMN_COUNT COLCOUNT INTEGER Number of columns in the foreign key.