Skip to main content

Namespace Varigence.Languages.Biml.Table

This namespace houses information regarding the SSIS table properties and methods that are supported in Biml.

Classes

NameDescription
AstCheckConstraintNodeDefines a Check constraint, which can be used to enforce that data in a table or column meets specific criteria.
AstDatabaseFileGroupNodeThe AstDatabaseFileGroupNode type provides properties to configure a group of file used to store the contents of a database on the database server.
AstDatabaseFileGroupResourceNodeAstDatabaseFileGroupResourceNode is used for creating references to database file groups that have been modeled in the Biml project.
AstDatabaseFileNodeThe AstDatabaseFileNode type provides properties to configure a file used to store the contents of a database on the database server.
AstDatabaseNodeDatabase 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.
AstExternalDatabaseFileGroupResourceNodeAstExternalDatabaseFileGroupResourceNode is used for creating references to database file groups that have not been modeled in the Biml project.
AstMultipleColumnTableReferenceNodeMultiple-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.
AstPartitionFunctionNodeDefines a partition function for relational partitioning
AstPartitionSchemeNodeDefines a scheme for mapping partitions to filegroups.
AstPrincipalNodeAstPrincipalNode defines a security principal that can be used across relational or Analysis Services databases.
AstSchemaNodeSchema objects correspond directly to SQL Server schemas, which are logical containers for tables, stored procedures, views, and other database objects.
AstServerNodeThis node represents a server. For example, it can represent a SQL Server instance.
AstStaticSourceColumnValueNodeThe 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.
AstStaticSourceRowNodeThe 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.
AstTableCloneNodeTableClone 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.
AstTableColumnBaseNodeAstTableColumnBaseNode is the base type that is used for all table column types in Biml.
AstTableColumnNodeColumns represent regular SQL Server table columns. They have no special properties or capabilities beyond regular SQL Server columns.
AstTableColumnReferenceNodeAstTableColumnReferenceNode 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.
AstTableColumnTableReferenceBaseNodeThis is an abstract base node for all Table and Dimension Reference column types.
AstTableColumnTableReferenceNodeTable 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.
AstTableHashedKeyColumnNodeHashed 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.
AstTableIdentityNodeAstTableIdentityNode is an abstract type that represents both an identity expression and optionally a primary key on a table in a SQL Server relational database.
AstTableIndexColumnNodeThe AstTableIndexColumnNode corresponds directly to a column reference from a parent table index in SQL Server.
AstTableIndexLeafNodeThe AstTableIndexLeafNode corresponds directly to a column include reference from a parent table index in SQL Server.
AstTableIndexNodeAstTableIndexNode corresponds directly to a SQL Server relational database index.
AstTableKeyBaseNodeAstTableKeyBaseNode is the base node for all types of keys and constraints that can be defined in a SQL Server relational database.
AstTableKeyColumnNodeThe AstTableKeyColumnNode corresponds directly to a column reference from a parent table key in SQL Server.
AstTableNodeTable 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.
AstTablePrimaryKeyNodeAstTablePrimaryKeyNode is an abstract type that represents a primary key constraint on a table in a SQL Server relational database.
AstTableSourceBaseNodeAstTableSourceBaseNode is the base type for all table source definitions in Biml.
AstTableStaticSourceNodeThe 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.
AstTableUniqueKeyNodeAstTableUniqueKeyNode is an abstract type that represents a unique column(s) constraint on a table in a SQL Server relational database.
AstViewNodeDefines a view, based on a SELECT statement and additional metadata.

Enums

NameDescription
ForeignKeyConstraintMode
PartitionBoundarySide
PrincipalType
ScdType
TableCompressionType
ViewType