TechNet
Export (0) Print
Expand All
Collapse the table of content
Expand the table of content
Expand Minimize

StorageEngineUsed Element (XMLA)

 

Applies To: SQL Server 2016 Preview

Contains a read-only value that describes the current database type.

  
<Databases>  
      <Database>  
      <Name>...</Name>  
      <ID>...</ID>  
      <CreatedTimestamp>...</CreatedTimestamp>  
      <LastSchemaUpdate>...</LastSchemaUpdate>  
      <LastUpdate>...</LastUpdate>  
      <Description>...</Description>  
      <State>   </State>  
      <AggregationPrefix>...</AggregationPrefix>  
      <EstimatedSize>...</EstimatedSize>  
      <LastProcessed>...</LastProcessed>  
      <Language>...</Language>  
            <Collation>...</Collation>  
            <Visible>...</Visible>  
      <MasterDatasourceID>...</MasterDataSourceID>  
      <Accounts>...</Accounts>  
      <DataSources>...</DataSources>  
      <DataSourceViews>...</DataSourceViews>  
            <Dimensions>...</Dimensions>  
      <Cubes>...</Cubes>  
            <MiningStructures>...</MiningStructures>  
      <Roles>...</Roles>  
      <Assemblies>...</Assemblies>  
      <DatabasePermissions>...</DatabasePermissions>  
      <Translations>...</Translations>  
      <Annotations>...</Annotations>  
            <StorageEngineUsed >...</StorageEngineUsed>  
   </Database>  
</Databases>  

CharacteristicDescription
Data type and lengthString (enumeration)
Default valueNone
Cardinality1-1: Required element that occurs once and only once.
RelationshipElement
Parent elementsdatabase
Child elementsNone

The value of this element is limited to one of the strings listed in the following table.

ValueDescription
TraditionalThe database model corresponds to a MOLAP, ROLAP, or HOLAP storage mode.
InMemoryThe database model corresponds to an IMBI storage mode.
MixedThe database model mixes IMBI and MOLAP, ROLAP, or HOLAP storage modes.

The enumeration that corresponds to the allowed values for StorageEngineUsed in the Analysis Management Objects (AMO) object model is StorageEngineUsed.

The elements that correspond to the parents of StorageEngineUsed in the Analysis Management Objects (AMO) object model are Database.

Community Additions

ADD
Show:
© 2016 Microsoft