Delete Relationships Between Tables In. In Manage relationships select New to open the Create relationship dialog box where we can select the tables columns and any additional settings we want for our relationship. Next to the relationship and then select Delete relationship.
To remove a table relationship you must delete the relationship line in the Relationships window. In the Manage Relationships dialog box select one or more relationships from the list. Keeping the relationship line selected hit the DELETE option.
DELETE returns the number of rows removed from the table.
Relationships specify the connection between tables and enable you to pull data together in meaningful ways. In SQL Server Data Tools click the Table menu and then click Manage Relationships. The relationship line appears thicker when it is selected. However you dont need to store both the customer and order information in the same table.