Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Applies to:
SQL Server - Windows only
Azure SQL Managed Instance
Important
Master Data Services (MDS) is removed in SQL Server 2025 (17.x) Preview. We continue to support MDS in SQL Server 2022 (16.x) and earlier versions.
In Master Data Services, delete a derived hierarchy when you are sure you no longer need it.
Note
Deleting a derived hierarchy has no effect on the attribute relationships that the hierarchy is based on.
Prerequisites
To perform this procedure:
You must have permission to access the System Administration functional area.
You must be a model administrator. For more information, see Administrators (Master Data Services).
To delete a derived hierarchy
In Master Data Manager, click System Administration.
From the menu bar, point to Manage and click Derived Hierarchies.
On the Derived Hierarchy Maintenance page, from the Model list, select a model.
Select the row for the derived hierarchy that you want to delete.
Click Delete.
In the confirmation dialog box, click OK.
See Also
Create a Derived Hierarchy (Master Data Services)
Derived Hierarchies (Master Data Services)