delete-an-explicit-hierarchy-master-data-services.md

title	Delete an Explicit Hierarchy
description	Delete an Explicit Hierarchy (Master Data Services)
author	meetdeepak
ms.author	dkhare
ms.reviewer	mikeray
ms.date	03/05/2026
ms.service	sql
ms.subservice	master-data-services
ms.topic	how-to
ms.custom	build-2025
helpviewer_keywords	explicit hierarchies, deleting deleting explicit hierarchies [Master Data Services]

Delete an Explicit Hierarchy (Master Data Services)

[!INCLUDE SQL Server - Windows only ASDBMI]

[!INCLUDE support-notice]

In [!INCLUDEssMDSshort], delete an explicit hierarchy when you no longer need it.

Warning

When you delete an explicit hierarchy, all consolidated members in the hierarchy are deleted also. If you delete all explicit hierarchies for an entity, all collections for the entity are also deleted and the entity is no longer enabled for explicit hierarchies and collections.

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 an explicit hierarchy

1. In [!INCLUDEssMDSmdm], click System Administration.

2. On the Manage Model page, select a model from the grid and then click Entities.

3. On the Manage Entity page, from the grid, select the row for the entity that contains the explicit hierarchy you want to delete.

4. Click Explicit Hierarchies.

5. On the Manage Explicit Hierarchy page, click the explicit hierarchy you want to delete.

6. Click Edit.

7. In the confirmation dialog box, click OK.

See Also

Create an Explicit Hierarchy (Master Data Services)
Explicit Hierarchies (Master Data Services)