SYSCONSTRAINT system view

Each row in the SYSCONSTRAINT system view describes a named constraint in the database. The underlying system table for this view is ISYSCONSTRAINT.

Column name	Data type	Description
constraint_id	UNSIGNED INT	The unique ID for the constraint.
constraint_type	CHAR(1)	The type of constraint: C – column check constraint T – table constraint P – primary key F – foreign key U – unique constraint
ref_object_id	UNSIGNED BIGINT	The object ID of the column, table, or index to which the constraint applies.
table_object_id	UNSIGNED BIGINT	The object ID of the table to which the constraint applies.
constraint_name	CHAR(128)	The name of the constraint.

Constraints on underlying system table

PRIMARY KEY (constraint_id)

FOREIGN KEY (ref_object_id) REFERENCES SYS.ISYSOBJECT (object_id)

FOREIGN KEY (table_object_id) REFERENCES SYS.ISYSOBJECT (object_id)

UNIQUE CONSTRAINT (table_object_id, constraint_name)