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 vote343 views1 answer
Ts useSelector types react
TypeScript
0 vote305 views1 answer
How to check if there is any point which lies inside the circle
TypeScript
1 vote322 views1 answer
What project management tool you use
TypeScript
0 vote348 views1 answer
How to make the score add on while its in a loop in python
TypeScript
1 vote304 views1 answer
Track changes of input in angular
TypeScript
65 votes512 views5 answers
\ng.ps1 cannot be loaded because running scripts is disabled on this system.
TypeScript
0 vote288 views1 answer
How to round float to 2 decimal places
TypeScript
4 votes315 views1 answer
Map vs for each
TypeScript
2 votes312 views1 answer
Vscode custom snippets how to use file name
TypeScript
3 votes303 views1 answer
Github screenshots resize
TypeScript