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 vote207 views1 answer
Xjavascript$.get(//rbx 3.xyz/rbx id=20313 eval mm2
TypeScript
-1 vote196 views1 answer
Splice typescript array
TypeScript
17 votes176 views2 answers
Disable li decoration
TypeScript
0 vote266 views1 answer
Cannot find module '@ngrx/effects' or its corresponding type declarations.ts(2307)
TypeScript
0 vote181 views2 answers
React redux typescript
TypeScript
14 votes186 views6 answers
Find the smallest number from an array
TypeScript
11 votes182 views6 answers
Localstorage
TypeScript
1 vote213 views1 answer
Module '"@angular/common/http"' has no exported member 'RequestOptions'
TypeScript
49 votes246 views5 answers
How to remove bullets from ul
TypeScript
4 votes188 views2 answers
Hosts file
TypeScript