This article is on how to drop a SQL Server index from an existing table on a given database. It can be a relational or a transactional database.
For instance, learn here why you need an index optimization plan on databasejournal.
How to drop a SQL Server index?
To drop any unnecessary index, simply copy paste this code example and adjust it with the index and table names. This code drops the index created in this article.
DROP INDEX indexYearMonth ON [dbo].[SALES];
Moreover, please note that after dropping the index, all the queries will be using the available primary key. So it can has a huge impact of performance.