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 vote157 views1 answer
Const formats = { time: { '24hour': {hour12: false, hours: 'numeric', minute: 'numeric'} } }; <IntlProvider locale={locale} messages={messages} formats={formats}> <FormattedTime value={someDate} format='24hour'/> </IntlProvider>
TypeScript
0 vote184 views1 answer
Install dependencies angular
TypeScript
12 votes179 views3 answers
Remove dots from li
TypeScript
1 vote185 views1 answer
Ts remainder of Division
TypeScript
22 votes181 views4 answers
Cmd listening ports
TypeScript
57 votes267 views3 answers
How to check list of open ports in linux
TypeScript
0 vote160 views1 answer
Can only use lower 16 bits for requestCode registerForActivityResult
TypeScript
0 vote172 views2 answers
Python remove accents pandas
TypeScript
0 vote175 views1 answer
Site:community.nxp.com dts gpio output high active
TypeScript
0 vote182 views1 answer
HTML form inputs to excel spreadsheet [duplicate]
TypeScript