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
Note Deleting a relationship from a database diagram marks the related tables as modified in all diagrams in which they appear.