How to delete a relationship
SQL Server 2000
Delete a relationship from the model if it is no longer needed.
To delete a relationship
- In the hierarchical pane of the Semantics tab of the Model Editor, expand the Relationship folder and right-click the relationship to delete.
- Click Delete.
- Click OK when prompted to delete the relationship.