Deleting a Foreign Key Constraint

Delete a foreign key constraint when you want to remove the requirement to enforce referential integrity between primary key columns and the related columns in another table.

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.