REFERENTIAL_CONSTRAINTS

The REFERENTIAL_CONSTRAINTS view contains one row for each referential constraint.

The following table describes the columns in the view:

Table 1. 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
COLUMN_COUNT INTEGER Count of columns in the constraint.
Parent topic: ANS and ISO catalog views