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 vote102 views1 answer
Find value in array ts
TypeScript
0 vote111 views1 answer
Script editor google sheets create new sheet
TypeScript
0 vote109 views1 answer
Unknown compiler option 'files' nativescript
TypeScript
3 votes109 views1 answer
Squash commits in remote branch
TypeScript
1 vote100 views1 answer
Insert value to the top of array in angular
TypeScript
1 vote108 views1 answer
How to use variables with if statements python
TypeScript
0 vote105 views3 answers
Input adresse ville automatique
TypeScript
1 vote98 views1 answer
Macos fonts download for linux ubuntu
TypeScript
1 vote103 views1 answer
How do you move data between the request
TypeScript
0 vote134 views1 answer
Difference between scripted testing and exploratory testing
TypeScript