ALTER TABLE <table> DROP INDEX <Index_Name>;
The table you want to delete an index from.
The Index name that has been defined in the table.
This SQL command does not return anything.