The following table shows the contents of the SYSCHECKS system table.
SYSCHECKS system table
For each column in the SYSCHECKS system table, this table provides its data type, its length in bytes, whether it is nullable, and a description of its contents.
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