Deleting a Foreign Key Constraint

Delete a foreign key constraint when you want to remove the requirement to enforce referential integrity.

To delete a foreign key constraint

In your database diagram, delete the relationship line that represents the foreign key constraint you want to delete. For details, see Deleting a Relationship.

Note Deleting a relationship from a database diagram marks the related tables as modified in all diagrams in which they appear.