To add a foreign key:

  1. Select Foreign Key from the tree. The Properties page appears.

  2. Click Create. The Create Foreign Key – Introduction window is displayed. Select Next at the bottom of the page, the Name the Foreign Key window is displayed.

  3. Enter the foreign key name in the Foreign Key Name text field.

  4. Select the referencing table name.

  5. Click checkboxes beside the column names to indicate which columns to include in the foreign key.

  6. Click Next. The Choose the primary key(s) from the other table window of the Create Foreign Key Wizard is displayed.

  7. Select the name of the referenced table from the Referenced Table menu.

    Note: Only tables containing primary keys or unique indexes that match the schema of the foreign key are shown.

  8. All the selected table columns that are primary keys or unique indexes will be displayed.

  9. Click Next. The Update action and Delete action window will open.


Related topic:

Adding a Foreign Key
To set foreign key options