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
Can't bind to 'ngbCollapse' since it isn't a known property of 'div'
TypeScript
5 votes149 views2 answers
Pass function as argument typescript
TypeScript
0 vote174 views1 answer
INFO: This is taking longer than usual. You might need to provide the dependency resolver with stricter constraints to reduce runtime.
TypeScript
1 vote104 views1 answer
How do you move data between the request
TypeScript
14 votes119 views6 answers
How to install bootstrap in angular 11
TypeScript
0 vote146 views1 answer
The marking menu shortcuts to context-sensitive commands and tools. Marking menu accessed for objects:
TypeScript
0 vote106 views3 answers
Typescript with babel
TypeScript
-2 votes117 views1 answer
How to randomly generate a string in ts
TypeScript
1 vote103 views1 answer
Typescript mix props
TypeScript
0 vote98 views1 answer
Add active class when element exists into an array vuejs
TypeScript