SYSCONSTRAINTS
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) |
CONSTRAINT-NAME | 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 |
Previous Page
Next Page
Table of Contents
Index