| OLE DB Programmer's Reference |  |
| OLE DB Programmer's Reference | |
GUID: DBSCHEMA_CHECK_CONSTRAINTS_BY_TABLE
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 CHECK_CONSTRAINTS_BY_TABLE rowset identifies the check constraints for a given table, defined in a catalog 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. |
| CHECK_CLAUSE | DBTYPE_WSTR | The WHERE clause specified in the CHECK clause. |
| DESCRIPTION | DBTYPE_WSTR | Human-readable description of the column. |