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 vote132 views1 answer
Google sheets add all numbers in a column with condition
TypeScript
1 vote149 views1 answer
Running scripts is disabled on this system nodemon
TypeScript
0 vote136 views1 answer
Typescript api request header
TypeScript
-1 vote155 views1 answer
Lua table to string
TypeScript
1 vote138 views1 answer
Requests use many proxy python
TypeScript
0 vote93 views1 answer
Change div with css
TypeScript
0 vote129 views1 answer
Types of pacemaker
TypeScript
1 vote133 views2 answers
No type arguments expected for interface Callback
TypeScript
0 vote156 views1 answer
Find unique elements in pandas and their connection with other column
TypeScript
0 vote126 views1 answer
Typescript isvalidguid
TypeScript