Dropping a Foreign Key Relationship

To drop a foreign key, use the Alter Table dialog box. Instructions for how to drop a foreign key relationship are provided below.

To drop a foreign key relationship:

1. Display the Alter Table dialog box for the dependent table.
2. In the Relationships group box, highlight a relationship name and click the Drop button.

   SQLWizard displays a - sign preceding the foreign key name to indicate it will be dropped when you exit the Alter Table dialog box.

   Note:

   If you realize you want to keep a foreign key (relationship) before exiting the Alter Table dialog box, double click the name of the foreign key and display the Drop Relationship dialog box. Click the Undo button. The - sign will be removed, and the foreign key will remain intact.

3. Click OK from the Alter Table dialog box to drop the foreign key.
4. Click OK to confirm altering the table.