Before you can drop an index, be sure the data server that contains the index is running,
and you created and established a connection to it.
In the Databases folder in Enterprise Explorer, under the database connection profile,
expand the Databases folder, and then expand the tree for a database
and then the tree for the appropriate schema owner.
Expand the Tables folder and the table that contains the index.
Under the
Indexes folder, find the index you want to
drop.