Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 12.0.0 » SQL Anywhere Server - SQL Reference » Views » System views

 

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 table ID of the table to which the constraint applies.
constraint_name CHAR(128) The name of the constraint.
 Constraints on underlying system table