SYSKEYS system table

The SYSKEYS table describes the specific information for primary key and unique constraints within the current database.

Derby generates an index on the table to back up each such constraint. The index name is the same as SYSKEYS.CONGLOMERATEID.

The following table shows the contents of the SYSKEYS system table.

Table 1. SYSKEYS system table
Column Name Type Length Nullable Contents
CONSTRAINTID CHAR 36 false Unique identifier for constraint
CONGLOMERATEID CHAR 36 false Unique identifier for backing index