Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 11.0.1 (Français) » UltraLiteJ » UltraLiteJ Reference » UltraLiteJ system tables

 

sysforeignkey system table

Each row in the sysforeignkey system table describes a foreign key that belongs to a table.

Column name Column type Description
table_id INTEGER The identifier of the table to which the foreign key belongs.
foreign_table_id INTEGER The identifier of the table to which this foreign-key-column refers to.
foreign_key_id INTEGER The identifier of the foreign key.
name VARCHAR(128) The name of the foreign key.
index_name VARCHAR(128) The name of the index the foreign key refers to.
Constraints

PRIMARY KEY (table_id, foreign_key_id)