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 vote307 views1 answer
React full calendar
TypeScript
1 vote325 views1 answer
COPY FROM instructs the PostgreSQL server process to read a file. You may want a client-side facility such as psql's \copy.
TypeScript
1 vote348 views1 answer
Css fonts system
TypeScript
0 vote308 views1 answer
Optional chaining
TypeScript
0 vote309 views1 answer
While converting HTML 4 elements to HTML 5 semantic elements, <div class="post"> will be converted into
TypeScript
2 votes292 views1 answer
Ionic 5 formarray
TypeScript
1 vote320 views1 answer
How to edit unity scripts in sublime text
TypeScript
0 vote311 views1 answer
Best way to display developer credits on a website
TypeScript
0 vote303 views1 answer
Sarasota bowling alley bomb threats incident
TypeScript
0 vote286 views1 answer
Error TS2339: Property 'open' does not exist on type 'MatDialogModule'.
TypeScript