• PRODUCTS
  • SUPPORT
  • DOCS
  • PARTNERS
  • COMPANY
  • QUOTE
  • ACCOUNT
  • STORE
QUOTE

Documentation

Support Forums
What can we help you with?
Topics

Columns

This is a container for table column definitions.
Permitted Collection Child Definitions
ChildAPI TypeDescription
<Column />AstTableColumnNodeColumns represent regular SQL Server table columns. They have no special properties or capabilities beyond regular SQL Server columns.
<HashedKey />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.
<MultipleColumnTableReference />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.
<TableReference />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.

© Varigence