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 vote154 views1 answer
Route resource adonis
TypeScript
0 vote159 views6 answers
How to add typescript tp create react app
TypeScript
0 vote193 views2 answers
Fibonacci counter in typescript
TypeScript
0 vote155 views1 answer
How to check if there is any point which lies inside the circle
TypeScript
4 votes195 views1 answer
Enumerate multiple lists python
TypeScript
2 votes167 views1 answer
Create model class angular
TypeScript
1 vote178 views1 answer
Whats the file path for the documents folder linux
TypeScript
1 vote172 views1 answer
Cmd check if folder exists or not
TypeScript
0 vote164 views1 answer
How to disable form control but keep value
TypeScript
-1 vote165 views1 answer
"gcm_sender_id":"15057814354"
TypeScript