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 vote254 views2 answers
Ts-node command compile typescript
TypeScript
1 vote225 views1 answer
Npx run ts file
TypeScript
0 vote243 views1 answer
Real time charts in flutter
TypeScript
0 vote247 views3 answers
How to get particular key value from array of objects in javascrip
TypeScript
0 vote292 views1 answer
How to make objects move in roblox studio with a loop
TypeScript
0 vote271 views1 answer
Apache poi get all worksheets from file input stream
TypeScript
0 vote246 views1 answer
How to get just the ports in kubernetes
TypeScript
0 vote255 views1 answer
How to take multiple int inputs in the same line in C++
TypeScript
3 votes248 views1 answer
Serenity.is disable row in grid
TypeScript
1 vote263 views1 answer
Ion slides updateAutoHeight
TypeScript