Export (0) Print
Expand All
Expand Minimize

Command Element (XMLA)

Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).

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).

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2015 Microsoft