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)