Index Dialog Box

Use the Create New Index and Edit Existing Index dialog boxes to define and modify indexes on the database and table specified in the Manage Indexes dialog box.

Options

Index name

Specify the name of the index to create or edit.

Column

Specify or change the columns in the selected index.

Sort Order

Specify or change the sort order for the column. The default order is descending.

Data type

View the data type of the column.

Length

Display the length of the selected column.

Nullable

Display whether the selected column is nullable.

Precision

Display the precision of the selected column.

Scale

Display the scale of the selected column.

Change column order

Change the position of the column in the index.

Move Up	Move the selected column up one.
Move Down	Move the selected column down one.

Index options

Specify the type of index and other index options.

Clustered index	Specify a clustered index.
Unique values	Specify to index the columns by unique values.
Ignore duplicate values	Specify to ignore duplicate values.
Do not recompute statistics (not recommended)	Specify to not recompute the statistics of the index. This is not recommended.
File group	Specify the filegroup of the index.
Pad index	Specify to pad the index. Padding the index leaves space on each interior node of the index.
Drop existing	Specify to delete any existing index of the same name before creating the new index.
Fill factor	Specify how full SQL Server should make the leaf level of each index page during index creation.

Edit SQL

Open the Edit Transact-SQL Script dialog box where you can edit the CREATE INDEX or ALTER INDEX statement.