Each row in the SYSCHECK system view provides the definition for a named check constraint in a table. The underlying system table for this view is ISYSCHECK.
| Column name | Data type | Description |
|---|---|---|
| check_id | UNSIGNED INT | A number that uniquely identifies the constraint in the database. |
| check_defn | LONG VARCHAR | The CHECK expression. |
PRIMARY KEY (check_id)
FOREIGN KEY (check_id) REFERENCES SYS.ISYSCONSTRAINT (constraint_id)