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.
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.
You can also manage indexes on some views.