Drop index if exists mysql

create procedure DeleteIndex()
begin

IF EXISTS ( SELECT * FROM INFORMATION_SCHEMA.STATISTICS  WHERE TABLE_NAME = 'TableName'
            AND INDEX_NAME = 'IndexName' AND INDEX_SCHEMA='DbName') THEN
   ALTER TABLE  TableName DROP index THead2;
END IF;
END

Source: stackoverflow.com

Similar codes

0 vote264 views1 answer
How test with limited information
TypeScript
4 votes179 views1 answer
How to find how many digits a number has in c++
TypeScript
2 votes175 views1 answer
Typescriprt specify type of key
TypeScript
12 votes172 views3 answers
Useref input typescript
TypeScript
17 votes168 views3 answers
Js null ==
TypeScript
0 vote169 views1 answer
Not able to use fonts awesome in react
TypeScript
-1 vote170 views1 answer
Fusion builder elegant elements for free
TypeScript
0 vote191 views1 answer
Print query from get_posts wordpress
TypeScript
0 vote174 views3 answers
Check table exists in db laravel
TypeScript
1 vote179 views3 answers
Typescript range
TypeScript