Dropping Indexes
If you find that you no longer need a named index, use a DROP INDEX statement to drop it.
DROP INDEX DeptHours#
For more information about the DROP INDEX statement, see the following topic in SQL Engine Reference: DROP INDEX.