---
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)
[!INCLUDE[appliesto-ss-asdb-asdw-pdw-md](../../includes/appliesto-ss-asdb-asdw-pdw-md.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 **<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](../../relational-databases/indexes/create-clustered-indexes.md)  
[Create Nonclustered Indexes](../../relational-databases/indexes/create-nonclustered-indexes.md)  
[Indexes - Keys Dialog Box &#40;Visual Database Tools&#41;](../../ssms/visual-db-tools/indexes-keys-dialog-box-visual-database-tools.md)