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 vote259 views1 answer
Get one property from list of objects linq
TypeScript
1 vote252 views1 answer
Route resource adonis
TypeScript
0 vote292 views1 answer
Mat-autocomplete options dropdown does not stick when scrolling
TypeScript
4 votes277 views2 answers
Magento 2 enable template hints command line
TypeScript
0 vote271 views1 answer
Empty string in typescript
TypeScript
4 votes308 views4 answers
Array.prototype.map() expects a return value from arrow function array-callback-return
TypeScript
0 vote225 views1 answer
How did mississauga get its name
TypeScript
2 votes271 views2 answers
Length array angular
TypeScript
7 votes327 views3 answers
Class 'kotlin.Unit' was compiled with an incompatible version of Kotlin. The binary version of its metadata is 1.5.1, expected version is 1.1.15.
TypeScript
0 vote275 views4 answers
Craeting a method that can take any number of arguments in python
TypeScript