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

Documentation

Support Forums
What can we help you with?
Topics

Table Primary Key Element

API Type:
Varigence.Languages.Biml.Table.AstTablePrimaryKeyNode
X-Ref:
  • Ast Table Primary Key Node
  • Ast Table Key Base Node

Attributes

AttributeAPI TypeDefaultDescription
NameString 
Specifies the name of the object. This name can be used to reference this object from anywhere else in the program. This is a required property
ClusteredBooleanfalse
This value specifies whether incoming rows that have a duplicate key value should produce a warning (and continue) or an error (and terminate). This property applies only for keys where the value of Unique is True. It is useful for enabling large bulk inserts to complete when duplicate rows exist.
FillFactorInt320
This value specifies what percentage of each index page the database engine should fill when creating or rebuilding the index.
IgnoreDupKeyBooleanfalse
This value specifies whether incoming rows that have a duplicate key value should produce a warning (and continue) or an error (and terminate). This property applies only for keys where the value of Unique is True. It is useful for enabling large bulk inserts to complete when duplicate rows exist.
IsEnabledBooleanTrue
Enables or Disables this constraint. Disabled constraints will not be generated in the emitted SQL statements but will have metadata available for other use.
PadIndexBooleanfalse
This value determines whether each intermediate level of the index is padded with extra open space in each page.
UniqueBooleantrue
This value specifies whether each key value is unique. When the value is True, no two rows have the same values across all of the columns participating in the key.

Collection Children

ChildAPI TypeDescription
<Columns>
    <Column />
</Columns>
AstTableKeyColumnNode
This is a container for key column reference definitions. This is a required property
<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.

© Varigence