SYSCONSTRAINTS

Describes the information common to all types of constraints in the distributed system. This includes primary key, unique, foreign key, and check constraints.

Table 1. SYSCONSTRAINTS system table
Column Name Type Length Nullable Contents
CONSTRAINTID CHAR 36 No Unique identifier for constraint
TABLEID CHAR 36 No Identifier for table (join with SYSTABLES.TABLEID)
CONSTRAINTNAME VARCHAR 128 No Constraint name (internally generated if not specified by user)
TYPE CHAR 1 No 'P' (primary key), 'U' (unique), 'C' (check), or 'F' (foreign key)
SCHEMAID CHAR 36 No Identifier for schema that the constraint belongs to (join with SYSSCHEMAS.SCHEMAID)
STATE CHAR 1 No 'E' for enabled, 'D' for disabled
REFERENCECOUNT INTEGER 10 No The count of the number of foreign key constraints that reference this constraint; this number can be greater than zero only for PRIMARY KEY and UNIQUE constraints