Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.
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||Column constraint|
|check_id||UNSIGNED INT||NOT NULL|
|check_defn||LONG VARCHAR||NOT NULL|
check_id A number that uniquely identifies the constraint in the database.
check_defn The CHECK expression.
PRIMARY KEY (check_id)
FOREIGN KEY (check_id) references SYS.ISYSCONSTRAINT (constraint_id)