REFERENTIAL_CONSTRAINTS Rowset

The REFERENTIAL_CONSTRAINTS rowset identifies the referential constraints defined in the catalog that are owned by a given user.

The REFERENTIAL_CONSTRAINTS rowset contains the following columns:

Column name Type indicator Description
CONSTRAINT_CATALOG DBTYPE_WSTR Catalog name. NULL if the provider does not support catalogs.
CONSTRAINT_SCHEMA DBTYPE_WSTR Unqualified schema name. NULL if the provider does not support schema.
CONSTRAINT_NAME DBTYPE_WSTR Constraint name.
UNIQUE_CONSTRAINT_ CATALOG DBTYPE_WSTR Catalog name in which the unique or primary key constraint is defined. NULL if the provider does not support catalogs.
UNIQUE_CONSTRAINT_ SCHEMA DBTYPE_WSTR Unqualified schema name in which the unique or primary key constraint is defined. NULL if the provider does not support schemas.
UNIQUE_CONSTRAINT_ NAME DBTYPE_WSTR Unique or primary key constraint name.
MATCH_OPTION DBTYPE_WSTR Specifies values as:
  • “NONE,” which indicates that no match type was specified.

  • “PARTIAL,” which indicates that a match type of PARTIAL was specified.

  • “FULL,” which indicates that a match type of FULL was specified.
UPDATE_RULE DBTYPE_WSTR If an update rule was specified, then the UPDATE_RULE value is one of:
  • “CASCADE,” which indicates that a referential action of CASCADE was specified.

  • “SET NULL,” which indicates that a referential action of SET NULL was specified.

  • “SET DEFAULT,” which indicates that a referential action of SET DEFAULT was specified.

  • “NO ACTION,” which indicates that a referential action of NO ACTION was specified.
DELETE_RULE DBTYPE_WSTR If a delete rule was specified, then the DELETE_RULE value is one of:
  • “CASCADE,” which indicates that a referential action of CASCADE was specified.

  • “SET NULL,” which indicates that a referential action of SET NULL was specified.

  • “SET DEFAULT,” which indicates that a referential action of SET DEFAULT was specified.

  • “NO ACTION,” which indicates that a referential action of NO ACTION was specified.
DESCRIPTION DBTYPE_WSTR Human-readable description of the column.

Default Sort Order: CONSTRAINT_CATALOG, CONSTRAINT_SCHEMA, CONSTRAINT_NAME, UNIQUE_CONSTRAINT_CATALOG, UNIQUE_CONSTRAINT_SCHEMA, UNIQUE_CONSTRAINT_NAME.