DB2 Universal Database for iSeries SQL Reference

REFERENTIAL_CONSTRAINTS

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.
  • NO ACTION
  • RESTRICT
DELETE_RULE VARCHAR(11) Delete Rule
  • NO ACTION
  • CASCADE
  • SET NULL
  • SET DEFAULT
  • RESTRICT


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