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

16 votes163 views6 answers
Create react native app typescript
TypeScript
1 vote135 views1 answer
Ion modal dismiss
TypeScript
0 vote140 views1 answer
Typescript import particular class from file
TypeScript
0 vote146 views1 answer
Does any event get triggered when checked value changes programatically?
TypeScript
0 vote144 views3 answers
Figma documentation
TypeScript
3 votes137 views1 answer
Results of 1812
TypeScript
0 vote148 views1 answer
The eval() function
TypeScript
1 vote159 views1 answer
Google sheets return number of unique items
TypeScript
0 vote151 views1 answer
Java write arraylist of objects to file
TypeScript
15 votes136 views2 answers
Angular number pipe
TypeScript