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 vote274 views1 answer
Property 'split' does not exist on type string
TypeScript
3 votes299 views1 answer
Serenity.is disable row in grid
TypeScript
1 vote321 views1 answer
Eslint missing file extension ts
TypeScript
0 vote278 views1 answer
Write in file in typescript
TypeScript
3 votes277 views1 answer
Intersect sets python
TypeScript
0 vote303 views1 answer
Array of objects for in
TypeScript
0 vote296 views4 answers
How to implement read more and readless in angular
TypeScript
0 vote345 views1 answer
Vba check if two sheets are the same
TypeScript
0 vote290 views1 answer
Export data in Documents outside sandbox in swift
TypeScript
0 vote313 views1 answer
"Why aren't all young neutron stars seen as pulsars?"
TypeScript