Delete a relationship when you no longer want to relate columns in two related tables. When you redesign tables, it’s often necessary to delete relationships and then recreate them after your new design is complete. For example, if you decide to normalize a database and store all address data in one table, you would delete all the relationships to address
columns between existing tables, create a new table containing the address
columns, and then create relationships from the new address
table to every table that requires an address.
To delete a relationship
Note When you delete a relationship, the relationship line is removed from your diagram and every other diagram in which it appears. It is deleted from the database when you save the diagram or either of the tables that it related.