Contains one row for each CHECK constraint.
Table 46. SYSCAT.CHECKS Catalog View
| Column Name | Data Type | Nullable | Description |
|---|---|---|---|
| CONSTNAME | VARCHAR(18) |
| Name of the check constraint (unique within a table.) |
| DEFINER | VARCHAR(128) |
| Authorization ID under which the check constraint was defined. |
| TABSCHEMA | VARCHAR(128) |
| Qualified name of the table to which this constraint applies. |
| TABNAME | VARCHAR(128) |
| |
| 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. |
| QUALIFIER | VARCHAR(128) |
| Value of the default schema at time of object definition. Used to complete any unqualified references. |
| TYPE | CHAR(1) |
| Type of check constraint:
|
| FUNC_PATH | VARCHAR(254) |
| The current SQL path that was used when the constraint was created. |
| TEXT | CLOB(64K) |
| The text of the CHECK clause. |