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 vote271 views1 answer
Alternative for .include in typescript
TypeScript
7 votes283 views3 answers
How to find how many commits i have done
TypeScript
6 votes266 views1 answer
Replace string in typescript
TypeScript
2 votes305 views1 answer
Typescript sum all array values
TypeScript
0 vote271 views1 answer
Correct this attempt to modify "product" or use "let" in its declaration. [+1 location]
TypeScript
-6 votes258 views4 answers
Could not find a declaration file for module 'react'
TypeScript
-1 vote290 views1 answer
Apexcharts dataURI style
TypeScript
1 vote275 views1 answer
Using log how can we find number of digits for a number in java
TypeScript
0 vote260 views1 answer
Must_not exists elastic search
TypeScript
0 vote243 views1 answer
Typescript getting started
TypeScript