The syntax is
ALTER TABLE table_name
DROP INDEX index_name;
You have:
Alter table cust_branch_item_stock Drop index index
is your index called
index
?
I would expect something more like:
Alter table `cust_branch_item_stock` Drop index `idx_<<tablename>>_<<column_name(s)>>`