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 vote44 views1 answer
Typescript type of component
TypeScript
2 votes40 views1 answer
Check if file exists laravel
TypeScript
5 votes48 views4 answers
Wget
TypeScript
8 votes46 views1 answer
If exists sql server
TypeScript
35 votes48 views6 answers
Add days to date javascript
TypeScript
3 votes0 view1 answer
Typescript loop through string
TypeScript
0 vote43 views1 answer
Cannot find name 'describe'. Do you need to install type definitions for a test runner? Try `npm i --save-dev @types/jest`
TypeScript
0 vote46 views1 answer
Unknown compiler option 'files' nativescript
TypeScript
2 votes49 views1 answer
Typescript sum all array values
TypeScript
1 vote47 views1 answer
Type script tuple type
TypeScript