Delete a Member or Collection (Master Data Services)
Applies To: SQL Server 2016 Preview
In Master Data Services, delete a member or collection when you no longer need it. If you want to delete members in bulk, use the staging tables instead. For more information, see Add, Update and Delete Data (Master Data Services)
You cannot delete a member if it is used as a domain-based attribute value for another member.
To perform this procedure:
You must have permission to access the Explorer functional area.
For members, you must have a minimum of Delete permission to the leaf model object you are deleting a member from.
For collections, you must have a minimum of Update permission to the leaf collection object you are deleting.
To delete a member or collection
On the Master Data Services home page, from the Model list, select a model.
From the Version list, select a version.
A leaf member, from the menu bar, point to Entities and click the name of the entity that contains the member.
A consolidated member, from the menu bar, point to Hierarchies and click the name of the hierarchy that contains the member. Then click the node in the hierarchy that contains the member.
A collection, from the menu bar, point to Collections and click the name of the entity that contains the collection.
In the grid, click the row of the member or collection you want to delete.
Click Delete Member, Delete, or Delete Collection.
In the confirmation dialog box, click OK.