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. |
Constraints |
Discuss this page in DocCommentXchange.
|
Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1 |