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 |