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 vote302 views1 answer
Check anagramm in typescript
TypeScript
0 vote221 views1 answer
Elements in body don't want to center
TypeScript
0 vote245 views1 answer
Order documents in firestore
TypeScript
0 vote215 views2 answers
Sum the digits in c
TypeScript
0 vote243 views1 answer
Minimum requirements to start it company
TypeScript
22 votes230 views4 answers
Generate random numbers in python within a range
TypeScript
0 vote217 views1 answer
Create Type from String Enum
TypeScript
0 vote222 views1 answer
Tkinter widgets overview
TypeScript
0 vote182 views1 answer
How to separately print digits of a number in python
TypeScript
0 vote231 views1 answer
How do you check ewhich version of typescript you are using
TypeScript