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 vote246 views1 answer
How to add id in array javascript
TypeScript
3 votes331 views2 answers
Array of objects how to check if property has duplicate
TypeScript
1 vote262 views1 answer
Custom decorator in loopback4
TypeScript
2 votes259 views2 answers
File_get_contents follow redirect
TypeScript
12 votes290 views3 answers
Python count number of digits in integer
TypeScript
0 vote271 views1 answer
Can i use different flutter versions for differnt progjects ?
TypeScript
0 vote264 views1 answer
Print gets opened whenever pdf is opened
TypeScript
2 votes255 views3 answers
Mat dialog disable close
TypeScript
0 vote252 views1 answer
Window open blob
TypeScript
2 votes217 views2 answers
Typescript array insert at index
TypeScript