To set foreign key options:

  1. Choose one of the following foreign key settings from the Update Action menu:

  2. Upon update of the referenced table the chosen update action will occur.

  3. Choose one of the following foreign key settings from the Delete Action menu:

  4. Upon update of the referenced table the chosen delete action will occur.

    Note: The default setting is No Action.

  5. Click Next. A window that allows the final review of all the SQL commands you provided to create the foreign key is displayed as shown below.

  6. Click Finish. The Properties page will reappear with the new foreign key in the list.


Related topic:

Setting Foreign Key Options