The SYSCHECKS table describes the check constraints within the current database.
The following table shows the contents of the 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 |