REFERENTIAL_CONSTRAINTS Rowset
GUID: DBSCHEMA_REFERENTIAL_CONSTRAINTS
Number of restriction columns: 3
Restriction columns: CONSTRAINT_CATALOG, CONSTRAINT_SCHEMA, CONSTRAINT_NAME
Default sort order: CONSTRAINT_CATALOG, CONSTRAINT_SCHEMA, CONSTRAINT_NAME, UNIQUE_CONSTRAINT_CATALOG, UNIQUE_CONSTRAINT_SCHEMA, UNIQUE_CONSTRAINT_NAME
Description: The REFERENTIAL_CONSTRAINTS rowset identifies the referential constraints defined in the catalog that are owned by a given user.
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 schemas. |
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 |
If a <match type> was specified, the MATCH_OPTION value is one of the following: "NONE" ? No <match type> was specified. "PARTIAL" ? A <match type> of PARTIAL was specified. "FULL" ? A <match type> of FULL was specified. |
UPDATE_RULE |
DBTYPE_WSTR |
If an <update rule> was specified, the UPDATE_RULE value is one of the following: "CASCADE" ? A <referential action> of CASCADE was specified. "SET NULL" ? A <referential action> of SET NULL was specified. "SET DEFAULT" ? A <referential action> of SET DEFAULT was specified. "NO ACTION" ? A <referential action> of NO ACTION was specified. |
DELETE_RULE |
DBTYPE_WSTR |
If a <delete rule> was specified, the DELETE_RULE value is one of the following: "CASCADE" ? A <referential action> of CASCADE was specified. "SET NULL" ? A <referential action> of SET NULL was specified. "SET DEFAULT" ? A <referential action> of SET DEFAULT was specified. "NO ACTION" ? A <referential action> of NO ACTION was specified. |
DESCRIPTION |
DBTYPE_WSTR |
Human-readable description of the constraint. |