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:
|
UPDATE_RULE | DBTYPE_WSTR | If an update rule was specified, then the UPDATE_RULE value is one of:
|
DELETE_RULE | DBTYPE_WSTR | If a delete rule was specified, then the DELETE_RULE value is one of:
|
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.