How to: Change Index Properties (Visual Database Tools)
Your index is automatically saved in the database when you save your table in Table Designer. The index is available for modification as soon as you create it.
To change index properties
In Object Explorer, right-click the table you want to open and click Design (Modify in SP1 or earlier).
From the Table Designer menu, click Indexes/Keys.
Select the index from the Selected Primary/Unique Key or Index list.
Change properties in the grid.
Your changes are saved to the database when you save the table.
Note
You can also manage indexes on some views.
See Also
Other Resources
Working with Indexes (Visual Database Tools)
Indexes/Keys Dialog Box (Visual Database Tools)