SYSCHECK system view

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 Column type Description
check_id UNSIGNED INT A number that uniquely identifies the constraint in the database.
check_defn LONG VARCHAR The CHECK expression.
Constraints on underlying system table

PRIMARY KEY (check_id)

FOREIGN KEY (check_id) references SYS.ISYSCONSTRAINT (constraint_id)