drop index

Sometimes you may need to delete index in SQL Server database. Here is how to drop index in SQL Server to remove index.