How to delete an index (Query Analyzer)

To delete an index

1. On the Query menu, click Show Execution Plan.
2. Execute the Transact-SQL script in the query pane.
3. In the result pane, click the Execution Plan tab.
4. Right-click the icon of the physical operator that represents the table containing the index that needs to be deleted, and then click Manage Indexes....
5. Optionally, in Database and Table, select the name of a different database and table.
6. In Existing indexes, click the name of the index to delete, and then click Delete.
7. Confirm the deletion.

See Also

Graphically Displaying the Execution Plan Using SQL Server Query Analyzer