Varigence, Inc.

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.

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.

AstPrincipalNode defines a security principal that can be used across relational or Analysis Services databases.

Schema objects correspond directly to SQL Server schemas, which are logical containers for tables, stored procedures, views, and other database objects.

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.

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.

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.

AstTableColumnBaseNode is the base type that is used for all table column types in Biml.

Columns represent regular SQL Server table columns. They have no special properties or capabilities beyond regular SQL Server columns.

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.

This is an abstract base node for all Table and Dimension Reference column types.

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.

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.

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.

The AstTableIndexColumnNode corresponds directly to a column reference from a parent table index in SQL Server.

The AstTableIndexLeafNode corresponds directly to a column include reference from a parent table index in SQL Server.

AstTableIndexNode corresponds directly to a SQL Server relational database index.

AstTableKeyBaseNode is the base node for all types of keys and constraints that can be defined in a SQL Server relational database.

The AstTableKeyColumnNode corresponds directly to a column reference from a parent table key in SQL Server.

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.

AstTablePrimaryKeyNode is an abstract type that represents a primary key constraint on a table in a SQL Server relational database.

AstTableSourceBaseNode is the base type for all table source definitions in Biml.

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.

AstTableUniqueKeyNode is an abstract type that represents a unique column(s) constraint on a table in a SQL Server relational database.