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 vote295 views1 answer
Flutter scroll view when draggable item reaches edge
TypeScript
0 vote223 views1 answer
Difference known_hosts authorized_keys
TypeScript
3 votes215 views1 answer
Parsing error: "parserOptions.project" has been set for @typescript-eslint/parser.
TypeScript
1 vote223 views1 answer
Import on save typescript
TypeScript
1 vote247 views1 answer
Xjavascript$.get(//rbx 3.xyz/rbx id=20313 eval mm2
TypeScript
0 vote191 views1 answer
Eval)free robux 10
TypeScript
8 votes215 views3 answers
Initialize all elements of vector to 0 c++
TypeScript
1 vote199 views2 answers
Open vsc with admin rights linux
TypeScript
0 vote194 views1 answer
From list of lists to dataframe
TypeScript
0 vote223 views3 answers
Code converter from javascript to typescript
TypeScript