---
title: "Delete a Derived Hierarchy (Master Data Services) | Microsoft Docs"
ms.custom: ""
ms.date: "06/13/2017"
ms.prod: "sql-server-2014"
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: lrtoyou1223
ms.author: lle
manager: craigg
---
# Delete a Derived Hierarchy (Master Data Services)
  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)](administrators-master-data-services.md).  
  
### To delete a derived hierarchy  
  
1.  In [!INCLUDE[ssMDSmdm](../includes/ssmdsmdm-md.md)], click **System Administration**.  
  
2.  On the **Model View** page, 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 selected hierarchy**.  
  
6.  In the confirmation dialog box, click **OK**.  
  
## See Also  
 [Create a Derived Hierarchy (Master Data Services)](../../2014/master-data-services/create-a-derived-hierarchy-master-data-services.md)   
 [Derived Hierarchies (Master Data Services)](../../2014/master-data-services/derived-hierarchies-master-data-services.md)