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

34 votes197 views4 answers
How to get duplicate elements in sql
TypeScript
0 vote175 views1 answer
Vestacp ports mysql
TypeScript
0 vote193 views1 answer
Threejs how to rotate around object's own center,instead of world center
TypeScript
0 vote188 views6 answers
Pdf to word converter
TypeScript
1 vote184 views2 answers
Check if element exists in array golang
TypeScript
1 vote176 views1 answer
Vue components import each other recursive
TypeScript
1 vote175 views1 answer
Ionic 4 set root page when logout
TypeScript
0 vote182 views1 answer
Email validation in typescript
TypeScript
1 vote189 views1 answer
Tepescript loop object
TypeScript
3 votes200 views1 answer
Ts reverse array
TypeScript