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 vote141 views1 answer
How to get pastebin contents c#
TypeScript
0 vote152 views1 answer
Cannot find module '@angular/cdk/a11y'
TypeScript
4 votes144 views2 answers
Import Entypo form vector icons
TypeScript
0 vote135 views1 answer
Ionic email validation
TypeScript
1 vote159 views1 answer
Aws sqs create fifo queue
TypeScript
0 vote139 views1 answer
Pass command line arguments with spaces cmd
TypeScript
0 vote150 views1 answer
Angular elementref parent
TypeScript
26 votes153 views4 answers
Typescript type from enum values
TypeScript
0 vote151 views1 answer
How to store image in realtime firebase using angularfire2 and angular 8
TypeScript
0 vote147 views1 answer
How to choose automation over manual testing
TypeScript