Share via


Command Element (XMLA)

Contains the command to be executed by the Execute method.

Syntax

<Execute>
   ...
   <Command>
      <Alter>...</Alter>
      <!-- or -->
      <Backup>...</Backup>
      <!-- or -->
      <Batch>...</Batch>
      <!-- or -->
      <BeginTransaction>...</BeginTransaction>
      <!-- or -->
      <Cancel>...</Cancel>
      <!-- or -->
      <ClearCache>...</ClearCache>
      <!-- or -->
      <CommitTransaction>...</CommitTransaction>
      <!-- or -->
      <Create>...</Create>
      <!-- or -->
      <Delete>...</Delete>
      <!-- or -->
      <DesignAggregations>...</DesignAggregations>
      <!-- or -->
      <Drop>...</Drop>
      <!-- or -->
      <Insert>...</Insert>
      <!-- or -->
      <Lock>...</Lock>
      <!-- or -->
      <MergePartitions>...</MergePartitions>
      <!-- or -->
      <NotifyTableChange>...</NotifyTableChange>
      <!-- or -->
      <Process>...</Process>
      <!-- or -->
      <Restore>...</Restore>
      <!-- or -->
      <RollbackTransaction>...</RollbackTransaction>
      <!-- or -->
      <Statement>...</Statement>
      <!-- or -->
      <Subscribe>...</Subscribe>
      <!-- or -->
      <Synchronize>...</Synchronize>
      <!-- or -->
      <Unlock>...</Unlock>
      <!-- or -->
      <Update>...</Update>
      <!-- or -->
      <UpdateCells>...</UpdateCells>
   </Command>
   ...
</Execute>

Element Characteristics

Characteristic Description

Data type and length

None

Default value

None

Cardinality

1-1: Required element that occurs once and only once.

Element Relationships

Relationship Element

Parent elements

Execute

Child elements

Alter, Backup, Batch, BeginTransaction, Cancel, ClearCache, CommitTransaction, Create, Delete, DesignAggregations, Drop, Insert, Lock, MergePartitions, NotifyTableChange, Process, Restore, RollbackTransaction, Statement, Subscribe, Synchronize, Unlock, Update, UpdateCells

Remarks

The Command element is used by the Execute method to relay commands to a data source. While the XML for Analysis (XMLA) 1.1 Specification supports only the Statement command, Microsoft SQL Server 2005 Analysis Services (SSAS) supports many new XMLA commands. For more information about the XMLA command supported by Analysis Services, see Commands (XMLA).

See Also

Concepts

Properties (XMLA)

Other Resources

XML Data Types (XMLA)

Help and Information

Getting SQL Server 2005 Assistance