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
.