---
description: "Delete a Derived Hierarchy (Master Data Services)"
title: Delete a Derived Hierarchy
ms.custom: ""
ms.date: "03/01/2017"
ms.prod: sql
ms.prod_service: "mds"
ms.reviewer: ""
ms.technology: master-data-services
ms.topic: conceptual
helpviewer_keywords: 
  - "deleting derived hierarchies [Master Data Services]"
  - "derived hierarchies, deleting"
ms.assetid: f46d660e-47f2-47ca-9372-1b5931540beb
author: CordeliaGrey
ms.author: jiwang6
---
# Delete a Derived Hierarchy (Master Data Services)

[!INCLUDE [SQL Server - Windows only ASDBMI  ](../includes/applies-to-version/sql-windows-only-asdbmi.md)]

  In [!INCLUDE[ssMDSshort](../includes/ssmdsshort-md.md)], 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)](../master-data-services/administrators-master-data-services.md).  
  
### To delete a derived hierarchy  
  
1.  In [!INCLUDE[ssMDSmdm](../includes/ssmdsmdm-md.md)], click **System Administration**.  
  
2.  From the menu bar, point to **Manage** and click **Derived Hierarchies**.  
  
3.  On the **Derived Hierarchy Maintenance** page, from the **Model** list, select a model.  
  
4.  Select the row for the derived hierarchy that you want to delete.  
  
5.  Click **Delete**.  
  
6.  In the confirmation dialog box, click **OK**.  
  
## See Also  
 [Create a Derived Hierarchy (Master Data Services)](../master-data-services/create-a-derived-hierarchy-master-data-services.md)   
 [Derived Hierarchies (Master Data Services)](../master-data-services/derived-hierarchies-master-data-services.md)