Biml API Reference
Varigence.Languages.Biml.Table Namespace
Classes
  Parent Type Summary
AstCheckConstraintNode
Defines a Check constraint, which can be used to enforce that data in a table or column meets specific criteria.
AstTableKeyBaseNode
AstTableKeyBaseNode is the base node for all types of keys and constraints that can be defined in a SQL Server relational database.
AstTableColumnReferenceNode
AstTableColumnReferenceNode is the base type for all column references in the Biml framework. It is used for eample in references to table columns from table indexes and keys.
AstTableKeyColumnNode
The AstTableKeyColumnNode corresponds directly to a column reference from a parent table key in SQL Server.
AstTableIndexColumnNode
The AstTableIndexColumnNode corresponds directly to a column reference from a parent table index in SQL Server.
AstTableIndexLeafNode
The AstTableIndexLeafNode corresponds directly to a column include reference from a parent table index in SQL Server.
AstTableIdentityNode
AstTableIdentityNode is an abstract type that represents both an identity expression and optionally a primary key on a table in a SQL Server relational database.
AstTablePrimaryKeyNode
AstTablePrimaryKeyNode is an abstract type that represents a primary key constraint on a table in a SQL Server relational database.
AstTableUniqueKeyNode
AstTableUniqueKeyNode is an abstract type that represents a unique column(s) constraint on a table in a SQL Server relational database.
AstTableSourceBaseNode
AstTableSourceBaseNode is the base type for all table source definitions in Biml.
AstTableStaticSourceNode
The AstTableStaticSourceNode type enables the definition of static data that will be loaded into the table on creation or when the static source is executed as a package target. If the table has an appropriate key specified, static source data can be merged into a table so that it can be changed and updated non-destructively.
AstStaticSourceRowNode
The AstStaticSourceRowNode type is used to define a full row of data that will populate a table through its static source. Static data that will be loaded into the table on creation or when the static source is executed as a package target. If the table has an appropriate key specified, static source data can be merged into a table so that it can be changed and updated non-destructively.
AstStaticSourceColumnValueNode
The AstStaticSourceColumnValueNode type is used to define a single column value within a row of data that will populate a table through its static source. Static data that will be loaded into the table on creation or when the static source is executed as a package target. If the table has an appropriate key specified, static source data can be merged into a table so that it can be changed and updated non-destructively.
AstTableIndexNode
AstTableIndexNode corresponds directly to a SQL Server relational database index.
AstPartitionSchemeNode
Defines a scheme for mapping partitions to filegroups.
AstPartitionFunctionNode
Defines a partition function for relational partitioning
AstServerNode
This node represents a server. For example, it can represent a SQL Server instance.
AstTableColumnBaseNode
AstTableColumnBaseNode is the base type that is used for all table column types in Biml.
AstTableHashedKeyColumnNode
Hashed Key Columns automatically create a computed column that is an SHA-1 hash of all of the columns included in the referenced constraint. This column type is useful for creating a single column key value that mirrors a chosen multi-column key.
AstTableColumnNode
Columns represent regular SQL Server table columns. They have no special properties or capabilities beyond regular SQL Server columns.
AstTableColumnTableReferenceBaseNode
This is an abstract base node for all Table and Dimension Reference column types.
AstTableColumnTableReferenceNode
Table reference columns are used to create a local column with a relationship to a key column of a table, dimension, or fact table. Table reference columns can be used only with single column foreign keys, and the column properties will be directly inferred from the key of the foreign table. Use the multiple column table reference for keys with multiple columns.
AstTableNode
Table objects correspond directly to regular tables in the SQL Server product. They support all of the same features and present all of the same limitations.
AstMultipleColumnTableReferenceNode
Multiple-column table references are used to create a local column with a relationship to a multiple-column key of a regular table. Multiple-column table references can be used with foreign keys having any number of columns. Use table reference columns for a version of table references that is optimized for single column keys.
AstTableCloneNode
TableClone enables you to create a copy of an existing table, allowing you to add your own additional columns, indexes, and keys in order to support staging mechanisms, temp-tables, etc.
AstSchemaNode
Schema objects correspond directly to SQL Server schemas, which are logical containers for tables, stored procedures, views, and other database objects.
AstDatabaseNode
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.
AstPrincipalNode
AstPrincipalNode defines a security principal that can be used across relational or Analysis Services databases.
AstDatabaseFileGroupNode
The AstDatabaseFileGroupNode type provides properties to configure a group of file used to store the contents of a database on the database server.
AstDatabaseFileNode
The AstDatabaseFileNode type provides properties to configure a file used to store the contents of a database on the database server.
AstViewNode
Defines a view, based on a SELECT statement and additional metadata.
AstDatabaseFileGroupResourceNode
AstDatabaseFileGroupResourceNode is used for creating references to database file groups that have been modeled in the Biml project.
AstExternalDatabaseFileGroupResourceNode
AstExternalDatabaseFileGroupResourceNode is used for creating references to database file groups that have not been modeled in the Biml project.
Enumerations
  Parent Type Summary
PrincipalType
The PrincipalType enumeration provides options for the different types of principals that can be assigned permissions in the Biml framework.
ScdType
The ScdType enumeration provides options for how changes to column values are treated in a slowly changing dimension table.
ForeignKeyConstraintMode
The ForeignKeyConstraintMode enumeration provides options for how the Biml compiler should emit relationships between tables relative to foreign key constraints.
TableCompressionType
The TableCompressionType enumeration provides options for what type of compression is used on the specified table.
PartitionBoundarySide
Indicates whether boundary values should be considered the left or right side or the partition.
ViewType
Defines whether a table should be emtted as a view
External Classes

This namespace has no external classes.

Extension Methods

This namespace has no extension methods.