REFERENTIAL_CONSTRAINTS Rowset

OLE DB Programmer's Reference

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.

1998-2001 Microsoft Corporation. All rights reserved.