Each row in the sysfkcol system table describes a foreign key column.
| Column name | Column type | Description |
|---|---|---|
| table_id | INTEGER | A unique identifier for the table to which the foreign key applies. |
| foreign_key_id | INTEGER | A unique identifier for the foreign key that this column belongs to. |
| item_no | SHORT | The order of the column in the foreign key. |
| column_id | INTEGER | A unique identifier of the table column that refers to the foreign column. |
| foreign_column_id | INTEGER | A unique identifier of the table column that is being referred to. |
PRIMARY KEY (table_id, foreign_key_id, item_no)
| Discuss this page in DocCommentXchange. Send feedback about this page using email. |
Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1 |