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 vote227 views1 answer
Get minutes between two dates ts
TypeScript
14 votes220 views3 answers
Df.value_counts to dataframe
TypeScript
1 vote199 views1 answer
District affected by latur earthquake
TypeScript
0 vote225 views1 answer
While converting HTML 4 elements to HTML 5 semantic elements, <div class="post"> will be converted into
TypeScript
9 votes235 views4 answers
Combine list of lists python
TypeScript
1 vote226 views1 answer
Sass migrate division vue
TypeScript
0 vote216 views1 answer
Formatting to six digits in python
TypeScript
0 vote219 views1 answer
Check schema exists postgresql
TypeScript
0 vote250 views1 answer
Pass class to generic typescript
TypeScript
0 vote221 views1 answer
Typescript final example
TypeScript