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 vote119 views1 answer
Remove all objects in R
TypeScript
0 vote125 views2 answers
Kotlin get first n elements from list
TypeScript
1 vote130 views1 answer
Node_modules/angularx-flatpickr/flatpickr.module.d.ts:6:64 - error TS2314: Generic type 'ModuleWithProviders<T>' requires 1 type argument(s).
TypeScript
0 vote117 views2 answers
Defining component layout next ts
TypeScript
7 votes130 views5 answers
Typescript foreach async await
TypeScript
0 vote151 views1 answer
How to remove duplcates elements from arraylist
TypeScript
-1 vote115 views1 answer
What are the three ways for a developer to execute tests in an org
TypeScript
6 votes177 views2 answers
Github:Module was compiled with an incompatible version of Kotlin. The binary version of its metadata is 1.5.1, expected version is 1.1.15 in android
TypeScript
35 votes130 views2 answers
Typescript last index of array
TypeScript
0 vote123 views1 answer
The dialect mongodb+srv is not supported. Supported dialects feathers
TypeScript