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 vote150 views1 answer
Url prod
TypeScript
0 vote222 views1 answer
- laravel/ui[v3.2.0, ..., 3.x-dev] require illuminate/console ^8.0 -> found illuminate/console[v8.0.0, ..., 8.x-dev] but these were not loaded, likely because it conflicts with another require.
TypeScript
0 vote182 views1 answer
Typescript assert non null
TypeScript
-1 vote150 views1 answer
Typescript declaring null
TypeScript
0 vote167 views1 answer
What are the common mistakes in software development
TypeScript
0 vote137 views1 answer
Property 'split' does not exist on type string
TypeScript
13 votes165 views4 answers
Ionic generate resources
TypeScript
0 vote159 views2 answers
How to teleport a sprite to a new room in game maker studio 2
TypeScript
0 vote144 views1 answer
How to make element increase in height as its innerHTML's height exapands
TypeScript
0 vote153 views1 answer
Using es6 set in typescript
TypeScript