Describes the information common to all types of constraints within
the current database (currently, this includes primary key, unique, foreign
key, and check constraints).
Column Name
Type
Length
Nullable
Contents
CONSTRAINTID
CHAR
36
false
unique identifier for constraint
TABLEID
CHAR
36
false
identifier for table (join with SYSTABLES.TABLEID)
CONSTRAINTNAME
VARCHAR
128
false
constraint name (internally generated if not specified
by user)
TYPE
CHAR
1
false
P (primary key), U (unique), C (check),
or F (foreign key)
SCHEMAID
CHAR
36
false
identifier for schema that the constraint belongs to (join
with SYSSCHEMAS.SCHEMAID)
STATE
CHAR
1
false
E for enabled, D for disabled
REFERENCECOUNT
INTEGER
1
false
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