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
Reference
Indexes/Keys Dialog Box (Visual Database Tools)
Other Resources
Clustered Index Design Guidelines
Nonclustered Index Design Guidelines
Working with Indexes (Visual Database Tools)
How to: Create Indexes (Visual Database Tools)