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 | Column type | Description |
---|---|---|
constraint_id | UNSIGNED INT | The unique ID for the constraint. |
constraint_type | CHAR(1) | The type of 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. |
PRIMARY KEY (constraint_id)
FOREIGN KEY (ref_object_id) references SYS.ISYSOBJECT (object_id)
FOREIGN KEY (table_object_id) references SYS.ISYSOBJECT (object_id)
Discuss this page in DocCommentXchange. Send feedback about this page using email. |
Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1 |