DB2 Universal Database for iSeries SQL Reference

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 123. 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.


[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]