drop-element-xmla.md

title	Drop Element (XMLA) | Microsoft Docs
ms.custom
ms.date	03/03/2017
ms.prod	sql-server-2016
ms.reviewer
ms.suite
ms.technology	analysis-services docset-sql-devref
ms.tgt_pltfrm
ms.topic	reference
apiname	Drop Element
apilocation	http://schemas.microsoft.com/analysisservices/2003/engine
apitype	Schema
applies_to	SQL Server 2016 Preview
f1_keywords	urn:schemas-microsoft-com:xml-analysis#Drop microsoft.xml.analysis.drop http://schemas.microsoft.com/analysisservices/2003/engine#Drop
helpviewer_keywords	Drop element
ms.assetid	a5d21db3-743a-4958-b16d-b6816a5ee787
caps.latest.revision	13
author	jeannt
ms.author	jeannt
manager	erikre

Drop Element (XMLA)

Deletes attribute members from a dimension.

Syntax

  
<Command>  
   <Drop>  
      <Object>...</Object>  
      <DeleteWithDescendants>...</DeleteWithDescendants>  
      <Where>...</Where>  
   </Drop>  
</Command>  

Element Characteristics

Characteristic	Description
Data type and length	None
Default value	None
Cardinality	0-n: Optional element that can occur more than once.

Element Relationships

Relationship	Element
Parent elements	Command
Child elements	DeleteWithDescendants, Object, Where

Remarks

The Drop command deletes attribute members from a write-enabled dimension.

For more information about deleting members, see Inserting, Updating, and Dropping Members (XMLA).

See Also

Insert Element (XMLA)
Update Element (XMLA)
Commands (XMLA)