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

1 vote277 views1 answer
Type annotations can only be used in TypeScript files.
TypeScript
0 vote266 views1 answer
Eliminate border white around components angular
TypeScript
0 vote293 views1 answer
Angular build failed to load router-outlet
TypeScript
8 votes304 views3 answers
Your account has reached its concurrent builds limit
TypeScript
0 vote280 views1 answer
Typescript vite static assets
TypeScript
2 votes274 views2 answers
Typescript object of type interface
TypeScript
1 vote248 views1 answer
What is test management review
TypeScript
1 vote292 views1 answer
Material ui circular progress coor
TypeScript
0 vote298 views2 answers
Sorting a vector of objects c++
TypeScript
1 vote271 views1 answer
Http requests in spring boot
TypeScript