Column Element for Index (DTA)
Applies To: SQL Server 2016
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>
Type: Optional. Specifies the index column type. Use a string data type to specify this attribute with one of the following allowed values:
Specifies that the column is referenced by an index key. Use the following syntax to set this attribute:
For more information about key columns, see Clustered and Nonclustered Indexes Described.
Specifies that the column is an included column (instead of a key column). Use the following syntax to set this attribute:
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:
|Data type and length||None.|
|Occurrence||Can specify up to 1024 columns for the Index element.|
|Parent element||Index Element (DTA)|
|Child elements||Name Element for Column (DTA)|
For a usage example of this element, see the XML Input File Sample with User-specified Configuration (DTA).