Each row in the SYSFKEY system view describes a foreign key constraint in the system. The underlying system table for this view is ISYSFKEY.
Column name | Column type | Description |
---|---|---|
foreign_table_id | UNSIGNED INT | The table number of the foreign table. |
foreign_index_id | UNSIGNED INT | The index number for the foreign key. |
primary_table_id | UNSIGNED INT | The table number of the primary table. |
primary_index_id | UNSIGNED INT | The index number of the primary key. |
match_type | TINYINT | The matching type for the constraint. Matching types include:
For more information about match types, see the MATCH clause of the CREATE TABLE statement. |
check_on_commit | CHAR(1) | Indicates whether INSERT and UPDATE statements should wait until the COMMIT to check if foreign keys are still valid. |
nulls | CHAR(1) | Indicates whether the columns in the foreign key are allowed to contain the NULL value. Note that this setting is independent of the nulls setting in the columns contained in the foreign key. |
PRIMARY KEY (foreign_table_id, foreign_index_id)
FOREIGN KEY (foreign_table_id, foreign_index_id) references SYS.ISYSIDX (table_id, index_id)
FOREIGN KEY (primary_table_id, primary_index_id) references SYS.ISYSIDX (table_id, index_id)
Discuss this page in DocCommentXchange. Send feedback about this page using email. |
Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1 |