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

title	description	author	ms.author	ms.date	ms.service	ms.subservice	ms.topic	helpviewer_keywords
Delete an Attribute	Delete an Attribute (Master Data Services)	CordeliaGrey	jiwang6	03/15/2017	sql	master-data-services	how-to	attributes [Master Data Services], deleting deleting attributes [Master Data Services]

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)