Cloudscape System Tables
Page 12 of 17

SYSKEYS

Describes the specific information for primary key and unique constraints within the current database. Cloudscape generates an index on the table to back up each such constraint. The index name is the same as SYSKEYS.CONGLOMERATEID.

Column Name

Type

Length

Nullable

Contents

CONSTRAINTID

CHAR

36

false

unique identifier for constraint

CONGLOMERATEID

CHAR

36

false

unique identifier for backing index

Indexes

SYSKEYS_INDEX1 unique BTREE index on (CONSTRAINTID)

Example Queries

The following query returns the name of the index backing up the primary key constraint called FlightAvailability_pk:

SELECT cn.CONGLOMERATENAME FROM SYS.SYSCONSTRAINTS c,
    SYS.SYSKEYS k, SYS.SYSCONGLOMERATES cn
WHERE c.CONSTRAINTID = k.CONSTRAINTID
AND k.CONGLOMERATEID = cn.CONGLOMERATEID
AND C.CONSTRAINTNAME = 'FLIGHTAVAILABILITY_PK'