Query : Query Drop Index

you can use this :
DROP INDEX index_name ON table_name; 

or this :
DROP INDEX table_name.index_name;  

or this :
ALTER TABLE table_nameDROP INDEX index_name;