Manage Indexes Dialog Box

Use the Manage Indexes dialog box to select the database and table or view for which you want to create, edit, or delete indexes.

Options

Database

Specify the database.

Table/view

Specify the table or view for the index.

Include system objects

Specify to include system objects in the list of tables and views.

Index

Specify an existing index in the selected database and table or view.

Clustered

Indicates whether the existing index is clustered.

Columns

Indicates the columns on which the index is based.

New

Open the Create New Index dialog box to define a new index on the selected database and table.

Edit

Edit the selected index in the Edit Existing Index dialog box.

Delete

Drop the selected index on the selected database and table.