The TABLE_CONSTRAINTS rowset identifies the table constraints defined in the catalog that are owned by a given user.
The TABLE_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 schemas. |
| CONSTRAINT_NAME | DBTYPE_WSTR | Constraint name. |
| 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_TYPE | DBTYPE_WSTR | Constraint type. One of the following:
"UNIQUE" |
| IS_DEFERRABLE | DBTYPE_BOOL | VARIANT_TRUE—The table constraint is deferrable. VARIANT_FALSE—The table constraint is not deferrable. |
| INITIALLY_DEFERRED | DBTYPE_BOOL | VARIANT_TRUE—The table constraint is initially deferred. VARIANT_FALSE—The table constraint is initially immediate. |
| DESCRIPTION | DBTYPE_WSTR | Human-readable description of the column |
Default Sort Order: CONSTRAINT_CATALOG, CONSTRAINT_SCHEMA, CONSTRAINT_NAME, TABLE_CATALOG, TABLE_SCHEMA, TABLE_NAME, CONSTRAINT_TYPE