Contains one row for each CHECK constraint defined for a table.
Table 78. OBJCAT.CHECKS Catalog View
| Column Name | Data Type | Nullable | Description |
|---|---|---|---|
| CONSTNAME | VARCHAR(18) |
| Name of the check constraint (unique within a table.) |
| DEFINER | CHAR(8) |
| Authorization ID under which the check constraint was defined. |
| TABSCHEMA | CHAR(8) |
| Qualified name of the table to which this constraint applies. |
| TABNAME | VARCHAR(18) |
| |
| ORIGIN_TABSCHEMA | CHAR(8) |
| Qualified name of the table on which the constraint was defined. |
| ORIGIN_TABNAME | VARCHAR(18) |
| |
| CREATE_TIME | TIMESTAMP |
| The time at which the constraint was defined. Used in resolving functions that are used in this constraint. No functions will be chosen that were created after the definition of the constraint. |
| FUNC_PATH | VARCHAR(254) |
| The current SQL path that was used when the constraint was created. |
| TEXT | CLOB(32K) |
| The text of the CHECK clause. |