Each row in the sysfkcol system table describes a foreign key column.
Column name | Column type | Description |
---|---|---|
table_id | UNSIGNED INTEGER | A unique identifier for the table to which the foreign key applies. |
foreign_key_id | UNSIGNED INTEGER | A unique identifier for the foreign key that this column belongs to. |
item_no | UNSIGNED SHORT | The order of the column in the foreign key. |
column_id | UNSIGNED SHORT | A unique identifier of the table column that refers to the foreign column. |
foreign_column_id | UNSIGNED SHORT | A unique identifier of the table column that is being referred to. |
Discuss this page in DocCommentXchange.
|
Copyright © 2010, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.0 |