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 votes194 views2 answers
Flutter dialog prevent close
TypeScript
0 vote202 views1 answer
Subplots titles
TypeScript
-6 votes225 views4 answers
Could not find a declaration file for module react native type script
TypeScript
0 vote194 views1 answer
List of objects where linq
TypeScript
0 vote205 views1 answer
How to start lammp in pirrots os
TypeScript
1 vote220 views1 answer
Psycopg2 OperationalError: FATAL: unsupported frontend protocol 1234.5679: server supports 2.0 to 3.0
TypeScript
1 vote205 views1 answer
If exists certain line in sql table java condition
TypeScript
6 votes150 views2 answers
After effects download
TypeScript
0 vote194 views1 answer
Real time charts in flutter
TypeScript
0 vote194 views1 answer
Createasyncthunk with typescript
TypeScript