GUID: DBSCHEMA_CONSTRAINT_TABLE_USAGE
Number of restriction columns: 6
Restriction columns: TABLE_CATALOG, TABLE_SCHEMA, TABLE_NAME, CONSTRAINT_CATALOG, CONSTRAINT_SCHEMA, CONSTRAINT_NAME
Default sort order: TABLE_CATALOG, TABLE_SCHEMA, TABLE_NAME, CONSTRAINT_CATALOG, CONSTRAINT_SCHEMA, CONSTRAINT_NAME
Description: The CONSTRAINT_TABLE_USAGE rowset identifies the tables that are used by referential constraints, unique constraints, check constraints, and assertions and that are defined in the catalog and owned by a given user.
|
Column name
|
Type indicator
|
Description
|
|---|
|
TABLE_CATALOG
|
DBTYPE_WSTR
|
Catalog name in which the table is defined. NULL if the provider does not support catalogs.
|
|
TABLE_SCHEMA
|
DBTYPE_WSTR
|
Unqualified schema name in which the table is defined. NULL if the provider does not support schemas.
|
|
TABLE_NAME
|
DBTYPE_WSTR
|
Table name.
|
|
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.
|