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.
Column Name | Type | Length | Nullable | Contents |
---|---|---|---|---|
CONSTRAINTID | CHAR | 36 | false | Unique identifier for constraint |
CONGLOMERATEID | CHAR | 36 | false | Unique identifier for backing index |