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

Reference

Insert Element (XMLA)
Update Element (XMLA)

Concepts

Commands (XMLA)

Help and Information

Getting SQL Server 2005 Assistance