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 vote164 views4 answers
Two form in rasa
TypeScript
0 vote139 views1 answer
PYTHON STACK FUNCTION count the valid number of brackets Returns the total number of valid brackets in the string
TypeScript
1 vote136 views2 answers
Property 'style' does not exist on type 'Element'
TypeScript
0 vote130 views1 answer
(Html.DevExtreme().FileUploader() dialogtrigger example
TypeScript
-1 vote230 views3 answers
Date time picker in angular material
TypeScript
0 vote126 views1 answer
How to get match percentage of lists in python
TypeScript
0 vote129 views1 answer
Routerextensions nativescript 7 import
TypeScript
0 vote136 views1 answer
Linux shell loop through all inputs except last
TypeScript
24 votes121 views4 answers
Children type typescript react'
TypeScript
0 vote129 views1 answer
No corners in broder css
TypeScript