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 vote143 views1 answer
Depth-first search that chooses values for one variable at a time and returns when a variable has no legal values left to assign
TypeScript
1 vote153 views1 answer
Reactive form disable
TypeScript
15 votes127 views2 answers
Which sentence has all alphabets
TypeScript
6 votes127 views1 answer
Typescript dictionary typing
TypeScript
0 vote139 views1 answer
Uncaught TypeError: Cannot read property 'value' of undefined at Object.onChange
TypeScript
3 votes137 views2 answers
Push at first index typescript
TypeScript
6 votes164 views1 answer
Replace string in typescript
TypeScript
0 vote192 views1 answer
Typescript add one month to date
TypeScript
0 vote134 views2 answers
Angular start date end date validation
TypeScript
0 vote159 views1 answer
Whats the tempurature
TypeScript