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 vote214 views1 answer
Typescript extend imported namespace
TypeScript
1 vote210 views1 answer
Custom decorator in loopback4
TypeScript
0 vote234 views2 answers
Npm WARN [email protected] requires a peer of tslint@^5.0.0 || ^6.0.0 but none is installed. You must install peer dependencies yourself.
TypeScript
0 vote205 views1 answer
Code solutions online for public IActionResult Student() { return View(Students Controller 1); }
TypeScript
2 votes206 views2 answers
Get last elements of list python
TypeScript
2 votes159 views1 answer
Visual Studio Code Typescript region folding
TypeScript
0 vote213 views1 answer
Compare two lists and find at least one equal python
TypeScript
0 vote229 views1 answer
Css how to make a elements of same type start at same height
TypeScript
1 vote211 views2 answers
Docker An attempt was made to access a socket in a way forbidden by its access permissions.
TypeScript
0 vote211 views2 answers
Use toasts in django
TypeScript