You can create a foreign key relationship between tables. A foreign key relationship acts as a constraint; for new rows inserted in the child table, the database server checks to see if the value you are inserting into the foreign key column matches a value in the primary table's primary key.
You must have DBA authority or be the owner of the table.
Context and remarks
You do not have to create a foreign key when you create a foreign table; the foreign key is created automatically.
Use the SQL Anywhere 12 plug-in to connect to the database as a user with
In the left pane, double-click Tables.
Select the table for which you want to create or delete a foreign key.
In the right pane, click the Constraints tab.
Create a foreign key:
Click File » New » Foreign Key.
Follow the instructions in the Create Foreign Key Wizard.
Discuss this page in DocCommentXchange.
|Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1|