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.

See Also

Constraints | Foreign Key Constraints