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