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

3 votes115 views2 answers
Foreach on dictionary in typescript
TypeScript
0 vote110 views1 answer
Typescript how to check if string is a date
TypeScript
3 votes134 views2 answers
Cannot find name 'require'. Do you need to install type definitions for node? Try `npm i @types/node` and then add `node` to the types field in your tsconfig.
TypeScript
0 vote120 views2 answers
Remove upsell products woocommerce
TypeScript
5 votes133 views1 answer
Close ports in windows
TypeScript
0 vote133 views3 answers
Typescript type of function
TypeScript
-1 vote125 views2 answers
Typescript initialize object
TypeScript
0 vote139 views1 answer
Directory. Relative imports outside of src/ are not supported.
TypeScript
0 vote68 views2 answers
Localstorage.getitem angular
TypeScript
32 votes132 views6 answers
List without bullets html
TypeScript