Editing a Foreign Key

Use the Foreign Key wizard to edit foreign key properties.

1. In the Table Editor, open the table where you want to edit a foreign key. The table appears in the Table Editor window.
2. Click the Foreign Keys tab.
3. Right-click the foreign key you want to edit and select Edit Foreign Key from the popup menu. The Foreign Key wizard appears.
4. Enter information in the Foreign Key wizard pages to edit the foreign key.
5. Click Finish to modify the foreign key. Icons for the new foreign key and its joins appear in the Foreign Keys page.
6. Choose Table->Execute to save the table to the database.