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 vote310 views1 answer
Convert int number in f#
TypeScript
0 vote304 views1 answer
Prototype design pattern typescript
TypeScript
0 vote302 views1 answer
How many arguments does a call to the Math.sqrt method have?
TypeScript
0 vote335 views1 answer
How to read excel spreadsheets in c++
TypeScript
10 votes296 views1 answer
Fucking sass
TypeScript
-1 vote303 views1 answer
Flutter get height of status bar
TypeScript
0 vote311 views1 answer
Typescript vite static assets
TypeScript
0 vote306 views1 answer
Typescript key values interface key from enum
TypeScript
0 vote289 views1 answer
From list of lists to dataframe
TypeScript
-1 vote305 views1 answer
Drupal
TypeScript