DROP INDEX TABLE_NAME.index_name (SQL Server)
DROP INDEX index_name ON TABLE_NAME (MS Access)
DROP INDEX index_name (DB2/Oracle)

ALTER TABLE TABLE_NAME
DROP INDEX index_name (MySQL)