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 |
Discuter à propos de cette page dans DocCommentXchange.
|
Copyright © 2013, SAP AG ou société affiliée SAP - SAP Sybase SQL Anywhere 16.0 |