How to: Delete Indexes (Visual Database Tools)
Indexes can slow INSERT, UPDATE, and DELETE performance. If you find that an index hinders overall performance or you no longer need it, you can delete it.
To delete an index
In Object Explorer, right-click the table with indexes you want to delete and click Design (Modify in SP1 or earlier).
From the Table Designer menu, click Indexes/Keys.
In the Indexes/Keys dialog box, select the index you want to delete.
Click Delete.
The index is deleted from the database when you save your table.
Note
If you delete an index in Table Designer but you do not want to delete it from the database you can close the table without saving changes. This will also discard all other changes made since the table was last saved.
See Also
Other Resources
Working with Indexes (Visual Database Tools)
Indexes/Keys Dialog Box (Visual Database Tools)
Working with Keys (Visual Database Tools)