Table Unique Key Element

API Type:

X-Ref:

Attribute	API Type	Default	Description
Name	String		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
Clustered	Boolean	false	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.
FillFactor	Int32	0	This value specifies what percentage of each index page the database engine should fill when creating or rebuilding the index.
IgnoreDupKey	Boolean	false	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.
IsEnabled	Boolean	True	Enables or Disables this constraint. Disabled constraints will not be generated in the emitted SQL statements but will have metadata available for other use.
PadIndex	Boolean	false	This value determines whether each intermediate level of the index is padded with extra open space in each page.
Unique	Boolean	true	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.

Child	API Type	Description
<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.