SYSCHECKS system table
Derby Reference Manual
221
Column Name
Type
Length
Nullable
Contents
SPECIFICNAME
VARCHAR
128
false
System-generated
identifier
SYSCHECKS system table
The SYSCHECKS table describes the check constraints within the current database.
The following table shows the contents of the SYSCHECKS system table.
Table 42.
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
REFERENCEDCOLUMNSorg.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
SYSCOLPERMS system table
The SYSCOLPERMS table stores the column permissions that have been granted but
not revoked.
All of the permissions for one (GRANTEE, TABLEID, TYPE, GRANTOR) combination are
specified in a single row in the SYSCOLPERMS table. The keys for the SYSCOLPERMS
table are:
· Primary key (GRANTEE, TABLEID, TYPE, GRANTOR)
· Unique key (COLPERMSID)
· Foreign key (TABLEID references SYS.SYSTABLES)
The following table shows the contents of the SYSCOLPERMS system table.
Table 43.
SYSCOLPERMS system table
Column Name
Type
Length
Nullable
Contents
COLPERMSID
CHAR
36
false
Used by the
dependency
manager to track
the dependency
of a view, trigger,
or constraint on
the column level
permissions
GRANTEE
VARCHAR
128
false
The authorization
ID of the user
or role to which
