In order to remove the index created the SQL command used is

225.

DELETE INDEX

DROP INDEX

ELIMINATE INDEX

REMOVE INDEX

Dropping an index
The following example deletes the index IX_ProductVendor_VendorID on the ProductVendor table.

DROP INDEX IX_ProductVendor_BusinessEntityID
ON Purchasing.ProductVendor;