Each row represents a column that is referenced by a check constraint or by the definition of a materialized query table. For table hierarchies, each check constraint is recorded only at the level of the hierarchy where the constraint was created.
Column Name | Data Type | Nullable | Description |
---|---|---|---|
CONSTNAME | VARCHAR (128) | Name of the check constraint. | |
TABSCHEMA | VARCHAR (128) | Schema name of the table containing the referenced column. | |
TABNAME | VARCHAR (128) | Unqualified name of the table containing the referenced column. | |
COLNAME | VARCHAR (128) | Name of the column. | |
USAGE | CHAR (1) |
|