Expand Databases, expand the database in which the table belongs, and then click Tables.
In the details pane, right-click the table, point to AllTasks, and then click Manage Indexes....
In Existingindexes, click the name of the index to modify, and then click Edit....
In Column, select the column you want to appear in the index. Composite indexes can be created by selecting more than one column.
Optionally, select a column, and then click either MoveUp or MoveDown to change the order of the columns in the index.
Optionally, in Indexoptions, select:
Uniquevalues to create a unique index.
Clusteredindex to create a clustered index. If a clustered index already exists, this option is not available.
Ignoreduplicatevalues to control what happens when an INSERT statement inserts multiple, nonunique key values into an index. For more information, see CREATE INDEX.
Do not recompute statistics (not recommended) to specify that index statistics are not automatically recomputed as the index is updated.
Filegroup to specify the filegroup on which to create the index. Click the name of the filegroup.
Padindex to leave space open on each interior node of the index. For more information, see CREATE INDEX.
Dropexisting to delete any existing index of the same name before creating the new index.
Fillfactor to specify how full SQL Server should make the leaf level of each index page during index creation. For more information, see CREATE INDEX.
Optionally, click Edit SQL... to view and edit the Transact-SQL statement used to create the index.