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 vote97 views2 answers
Pywavelets tutorial
TypeScript
0 vote105 views1 answer
Roblox how to weld parts together using script
TypeScript
1 vote96 views2 answers
Adjust distance of subplots in python
TypeScript
0 vote97 views2 answers
File_get_contents url fail
TypeScript
0 vote129 views1 answer
Typescript ingerit
TypeScript
3 votes103 views2 answers
Foreach on dictionary in typescript
TypeScript
0 vote126 views1 answer
> Cannot choose between the following variants of project :react-native-camera:
TypeScript
0 vote91 views1 answer
Property 'kName' does not exist on type '{}'
TypeScript
0 vote134 views1 answer
Requests to check is url exists in python using function
TypeScript
0 vote102 views1 answer
How to delete a struct in a arra of strcts c
TypeScript