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

7 votes332 views1 answer
How many alphabets in english
TypeScript
1 vote363 views1 answer
'react-scripts' is not recognized as an internal or external command, operable program or batch file. npm ERR! code ELIFECYCLE npm ERR! errno 1 npm ERR! [email protected] start: `react-scripts start` npm ERR! Exit status 1
TypeScript
0 vote326 views1 answer
React-jsonschema-form is not assignable to type 'JSONSchema6'
TypeScript
2 votes323 views1 answer
MySQL cheatsheets
TypeScript
0 vote376 views1 answer
Css how to make a elements of same type start at same height
TypeScript
0 vote348 views1 answer
Ratio of subplots matplotlib
TypeScript
0 vote350 views1 answer
Creating different objects in node.js
TypeScript
1 vote330 views1 answer
Select all inputs that arent checkboxes
TypeScript
0 vote319 views1 answer
Elements in body don't want to center
TypeScript
0 vote361 views1 answer
World-times-newspaper-magazine-style-ghost-blog-theme
TypeScript