SYSCHECKS2 catalog table
The SYSCHECKS2 table contains one row for each check constraint for catalog tables created in DB2® version 7 or later. The schema is SYSIBM. Check constraints for catalog tables created in releases earlier than DB2 version 7 are not included in this table.
| Column name | Data type | Description | Use |
|---|---|---|---|
| TBOWNER | VARCHAR(128)
NOT NULL |
The schema of the table on which the check constraint is defined. |
G |
| TBNAME | VARCHAR(128)
NOT NULL |
Name of the table on which the check constraint is defined. | G |
| CHECKNAME | VARCHAR(128)
NOT NULL |
Check constraint name. | G |
| PATHSCHEMAS | VARCHAR(2048)
NOT NULL |
SQL path at the time the check constraint was created. The path is used to resolve unqualified cast function names that are used in the constraint definition. | G |
| IBMREQD | CHAR(1)
NOT NULL |
A value of Y indicates that the row was provided with the Db2 product code. For all other values, see Release dependency indicators. The value in this field is not a reliable indicator of release dependencies. RELCREATED should be used instead. |
G |
| RELCREATED | CHAR(1)
NOT NULL |
The release of Db2 that is used to create the object. Blank if created prior to Version 9. See Release dependency indicators for all other values. | G |