Index Columns Dialog Box

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.

Note

The dialog boxes and menu commands you see might differ from those described in Help depending on your active settings or edition. To change your settings, choose Import and Export Settings on the Tools menu. For more information, see Visual Studio Settings.

  • 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

Tasks

How to: Create Indexes

Reference

Indexes/Keys Dialog Box

Other Resources

Working with Indexes