How to delete an index (Enterprise Manager)

To delete an index

1. Expand a server group; then expand a server.
2. Expand Databases, expand the database in which the table containing the index belongs, and then click Tables.
3. In the details pane, right-click the table, point to All Tasks, and then click Manage Indexes....
4. In Existing indexes, click the name of the index to delete, and then click Delete.
5. Confirm the deletion.

See Also