Biml Language Reference
Database Element
Database objects correspond directly to SQL Server databases, which are logical containers for tables, stored procedures, views, schemas, and other database objects. Note that databases are currently not used to genereate SQL code and can only be used to enable tables and schemas with the same unqualified name to be generated by the BIML framework.
Attributes
  Attribute API Type Default Description
ConnectionName AstDbConnectionNode
Refers to the connection used to access this database

[.NET API Property: Connection]

LogicalDisplayFolder String
Specifies a path that should be used for organizing the tree display of this object in the Logical View in BimlStudio.

[.NET API Property: LogicalDisplayFolder]

Name String
Specifies the name of the object. This name can be used to reference this object from anywhere else in the program.

[.NET API Property: Name]

PackageSubpath String
This specifies a file path fragment to use for emitting output files for this database. It is most commonly employed to ensure that the output files for multiple objects will be placed into the same output directory.

[.NET API Property: PackageSubpath]

ServerName AstServerNode
References the server instance that contains this database.

[.NET API Property: Server]

Collection Children
  Child API Type Description
<Annotations>
    <Annotation />
</Annotations>
AstAnnotationNode
This is a collection of annotation items that can be used to specify documentation, tags, or other information. Annotations are particularly useful for storing information about nodes that can be used by BimlScript code.

[.NET API Property: Annotations]

<CustomExtensions>
    <CustomExtension />
</CustomExtensions>
AstCustomExtensionContainerTaskNode
This collection specifies the definition for one or more SSIS package containers that can be used to execute custom actions relevant to the creation of this database. This is useful for creating stored procedures, custom constraints, and other custom operations.

[.NET API Property: CustomExtensions]

<FileGroups>
    <FileGroup />
</FileGroups>
AstDatabaseFileGroupNode
Defines the avaliable file groups in the database.

[.NET API Property: FileGroups]

<PartitionFunctions>
    <PartitionFunction />
</PartitionFunctions>
AstPartitionFunctionNode
Defines the avaliable partition functions in the database.

[.NET API Property: PartitionFunctions]

<PartitionSchemes>
    <PartitionScheme />
</PartitionSchemes>
AstPartitionSchemeNode
Defines the available partition schemes in the database.

[.NET API Property: PartitionSchemes]