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 vote200 views1 answer
Stripe typescript
TypeScript
0 vote192 views1 answer
Avoid hitting multiple same api hits angular
TypeScript
0 vote193 views1 answer
Ggplots in r
TypeScript
0 vote195 views2 answers
Android java loop through all objects in layout
TypeScript
0 vote181 views1 answer
Mat-checkbox change
TypeScript
0 vote196 views1 answer
UTorrent Default Download Folder - Linux
TypeScript
0 vote148 views1 answer
Laravel validation check if id exists in table
TypeScript
1 vote197 views1 answer
Unity lists number of
TypeScript
5 votes187 views1 answer
Requirements of fortnite
TypeScript
1 vote180 views1 answer
Whats the file path for the documents folder linux
TypeScript