GUID: DBSCHEMA_ASSERTIONS
Number of restriction columns: 3
Restriction columns: CONSTRAINT_CATALOG, CONSTRAINT_SCHEMA, CONSTRAINT_NAME
Default sort order: CONSTRAINT_CATALOG, CONSTRAINT_SCHEMA, CONSTRAINT_NAME
Description: The ASSERTIONS rowset identifies the assertions 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. |
IS_DEFERRABLE | DBTYPE_BOOL | VARIANT_TRUE—The assertion is deferrable.
VARIANT_FALSE—The assertion is not deferrable. |
INITIALLY_DEFERRED | DBTYPE_BOOL | VARIANT_TRUE—The assertion is initially deferred.
VARIANT_FALSE—The assertion is initially immediate. |
DESCRIPTION | DBTYPE_WSTR | Human-readable description of the column. |