delete-an-attribute-master-data-services.md

description	Delete an Attribute (Master Data Services)
title	Delete an Attribute
ms.custom
ms.date	03/15/2017
ms.prod	sql
ms.prod_service	mds
ms.reviewer
ms.technology	master-data-services
ms.topic	conceptual
helpviewer_keywords	attributes [Master Data Services], deleting deleting attributes [Master Data Services]
ms.assetid	ec3e66f7-0e35-43d7-a80d-64899948ebfe
author	CordeliaGrey
ms.author	jiwang6

Delete an Attribute (Master Data Services)

[!INCLUDE SQL Server - Windows only ASDBMI ]

In [!INCLUDEssMDSshort], delete an attribute when you want to permanently delete the attribute and all associated attribute values.

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 attribute

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, select the row for the entity that you want to create an attribute for.

4. Click Attributes.

5. On the Manage Attributes page, do one of the following.

   • If the attribute is for leaf members, select Leaf from the Member Types list box.

   • If the attribute is for consolidated members, select Consolidated from the Member Types list box.

   • If the attribute is for collections, select Collection from the Member Types list box.

6. Select the row for the attribute you want to delete.

   [!NOTE]
   You cannot delete the Name or Code attributes.

7. Click Delete.

8. In the confirmation dialog box, click OK.

See Also

Attributes (Master Data Services)
Domain-Based Attributes (Master Data Services)
Create a Text Attribute (Master Data Services)
Create a Domain-Based Attribute (Master Data Services)