Export (0) Print
Expand All

Column Element for Index (DTA)

Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).

Specifies the columns on which the index is created for a user-specified configuration.

<Create>
  <Index>
    <Name>...</Name>
    <Column [Type | SortOrder]>
     ...code removed here...
     </Column>

Column Attribute

Description

Type

Optional. Specifies the index column type. Use a string data type to specify this attribute with one of the following allowed values:

  • KeyColumn

    Specifies that the column is referenced by an index key. Use the following syntax to set this attribute:

    <Column Type="KeyColumn">
    

    For more information about key columns, see Clustered and Nonclustered Indexes Described.

  • IncludedColumn

    Specifies that the column is an included column (instead of a key column). Use the following syntax to set this attribute:

    <Column Type="IncludedColumn">
    

    For more information about included columns, see Create Indexes with Included Columns.

SortOrder

Optional. Specifies the sorting order of the column. Use a string data type to specify either an "Ascending" or "Descending" sorting order as follows:

<Column SortOrder="Ascending">

Characteristic

Description

Data type and length

None.

Default value

None.

Occurrence

Can specify up to 1024 columns for the Index element.

Relationship

Elements

Parent element

Index Element (DTA)

Child elements

Name Element for Column (DTA)

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2015 Microsoft