SYSCHECKS catalog table
The SYSIBM.SYSCHECKS table contains one row for each check constraint. The schema is SYSIBM.
| Column name | Data type | Description | Use |
|---|---|---|---|
| TBOWNER | VARCHAR(128)
NOT NULL |
The schema of the table on which the check constraint is defined. |
G |
| CREATOR | VARCHAR(128)
NOT NULL |
Authorization ID of the creator of the check constraint. | G |
| DBID | SMALLINT
NOT NULL |
Internal identifier of the database for the check constraint. | S |
| OBID | SMALLINT
NOT NULL |
Internal identifier of the check constraint. | S |
| TIMESTAMP | TIMESTAMP
NOT NULL |
Time when the check constraint was created. | G |
| RBA | CHAR(10)
NOT NULL FOR BIT DATA |
The log RBA when the check constraint was created. | 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. | 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 |
| CHECKCONDITION | VARCHAR(7400)
NOT NULL |
Text of the check constraint. | 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. The value in this field is not a reliable indicator of release dependencies. RELCREATED should be used instead. |
G |
| ENVID | INTEGER
NOT NULL WITH DEFAULT |
Internal environment identifier. | G |
| PERIOD | CHAR(1)
NOT NULL WITH DEFAULT |
The type of period associated with the check constraint:
|
G |