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

1 vote165 views1 answer
Angular change element style on click
TypeScript
1 vote219 views1 answer
Check all elements in list are false python
TypeScript
0 vote188 views1 answer
Angular elementref parent
TypeScript
1 vote224 views1 answer
Execute only one test spec with angular-cli (ng test)
TypeScript
0 vote273 views1 answer
Pcmanfm ubuntu
TypeScript
-1 vote190 views2 answers
Hhow to remove elements from java
TypeScript
2 votes187 views1 answer
Reactive form programmatically set value
TypeScript
31 votes184 views1 answer
Microsoft execution policies
TypeScript
-4 votes185 views1 answer
Whats a group of pandas called
TypeScript
0 vote174 views1 answer
How to join all url segments to make a url in javascipt 30seconds of code
TypeScript