index-columns-dialog-box-visual-database-tools.md

title	Index Columns Dialog Box
ms.custom	seo-lt-2019
ms.date	01/19/2017
ms.prod	sql
ms.prod_service	sql-tools
ms.technology	ssms
ms.topic	conceptual
f1_keywords	vdt.dlgbox.indexcolumns
ms.assetid	855860ae-528f-48ab-80e3-f53e7cb8c33f
author	markingmyname
ms.author	maghan
ms.manager	jroth
ms.reviewer

Index Columns Dialog Box (Visual Database Tools)

[!INCLUDEappliesto-ss-asdb-asdw-pdw-md] Use this dialog box to select the columns for an index and set their sort orders. An index can use one or more columns, and each column can be sorted either in ascending or descending order. To access this dialog box, in the Indexes/Keys dialog, click the ellipsis button for the Columns row in the General section.

Options

Column Name
Choose the columns that participate in this index. Select to remove that column from the index..

Sort Order
Select a sort order for the specified column. Available options are Ascending or Descending.

See Also

Create Clustered Indexes
Create Nonclustered Indexes
Indexes - Keys Dialog Box (Visual Database Tools)