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

title	Delete an Attribute
description	Delete an Attribute (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	attributes [Master Data Services], deleting deleting attributes [Master Data Services]

Delete an Attribute (Master Data Services)

[!INCLUDE SQL Server - Windows only ASDBMI]

[!INCLUDE support-notice]

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)