The following table shows the contents of the SYSCHECKS system table.
SYSCHECKS system table
Column Name
Type
Length
Nullable
Contents
CONSTRAINTID
CHAR
36
false
Unique identifier for the constraint
CHECKDEFINITION
LONG VARCHAR
32,700
false
Text of check constraint definition
REFERENCEDCOLUMNS
org.apache.derby.
catalog.
ReferencedColumns This class
is not part of the public API.
2,147,483,647
false
Description of the columns referenced by the check constraint