Skip to content

Latest commit

 

History

History
90 lines (79 loc) · 4.97 KB

File metadata and controls

90 lines (79 loc) · 4.97 KB
title Database Element (ASSL) | Microsoft Docs
ms.custom
ms.date 03/14/2017
ms.prod sql-server-2016
ms.reviewer
ms.suite
ms.technology
analysis-services
docset-sql-devref
ms.tgt_pltfrm
ms.topic reference
apiname
Database Element
apilocation
apitype Schema
applies_to
SQL Server 2016 Preview
f1_keywords
DATABASE
helpviewer_keywords
Database element
ms.assetid c3bc7eaf-ed0d-4395-a3b7-8d9cfacfe911
caps.latest.revision 41
author Minewiskan
ms.author owend
manager erikre

Database Element (ASSL)

Defines a [!INCLUDEmsCoName] [!INCLUDEssNoVersion] [!INCLUDEssASnoversion] database.

Syntax

  
<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>  
   </Database>  
</Databases>  

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 Databases
Child elements Accounts, AggregationPrefix, Annotations, Assemblies, Collation, CreatedTimestamp, Cubes, DatabasePermissions, DataSources, DataSourceViews, Description, Dimensions, EstimatedSize, ID, Language, LastProcessed, LastSchemaUpdate, LastUpdate, MasterDatasourceID, MiningStructures, Name, Roles, State, Translations, Visible

Remarks

The corresponding element in the Analysis Management Objects (AMO) object model is xref:Microsoft.AnalysisServices.Database.

See Also

Server Element (ASSL)
Objects (ASSL)