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

title	Index Columns Dialog Box (Visual Database Tools) | Microsoft Docs
ms.custom
ms.date	06/13/2017
ms.prod	sql-server-2014
ms.reviewer
ms.technology	ssms
ms.topic	conceptual
f1_keywords	vdt.dlgbox.indexcolumns
ms.assetid	855860ae-528f-48ab-80e3-f53e7cb8c33f
author	stevestein
ms.author	sstein
manager	craigg

Index Columns Dialog Box (Visual Database Tools)

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 <None> 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 and Keys Dialog Box (Visual Database Tools)