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 vote333 views1 answer
Delete the last string from file in typescript
TypeScript
0 vote312 views1 answer
Keyboard shortcuts to delete whole word using backspace
TypeScript
0 vote320 views1 answer
Sets letter latex
TypeScript
0 vote338 views1 answer
Remove wordpress products all at once
TypeScript
6 votes319 views1 answer
Typescript map list to new list of objects
TypeScript
0 vote352 views1 answer
Brackets equation latex
TypeScript
2 votes301 views1 answer
Cra template-typescript cmd
TypeScript
2 votes365 views1 answer
Typescript sum all array values
TypeScript
0 vote321 views1 answer
Return from r in restaurants orderby r.Name select r c#
TypeScript
0 vote331 views1 answer
Terminal prompts disabled
TypeScript