Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Command Element
Collapse the table of content
Expand the table of content

Command Element (XMLA)

 

Applies To: SQL Server 2016 Preview

Contains the command to be executed by the Execute method.


<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 -->
      <SetPasswordEncryptionKey>...</SetPasswordEncryptionKey>
      <!-- or -->
      <Statement>...</Statement>
      <!-- or -->
      <Subscribe>...</Subscribe>
      <!-- or -->
      <Synchronize>...</Synchronize>
      <!-- or -->
      <Unlock>...</Unlock>
      <!-- or -->
      <Update>...</Update>
      <!-- or -->
      <UpdateCells>...</UpdateCells>
   </Command>
   ...
</Execute>

Characteristic

Description

Data type and length

None

Default value

None

Cardinality

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

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 Analysis Services supports many new XMLA commands. For more information about the XMLA command supported by Analysis Services, see Commands (XMLA).

Community Additions

ADD
Show:
© 2015 Microsoft