1、单个索引删除
alter table dade_cs drop index name ;
dade_cs 是表
name是索引名称
2、删除多个索引
alter table cdj_order_490
drop index weiyi,
drop index xsc_id,
drop index meter_id,
drop index number;
alter table cdj_order_490 drop index weiyi,drop index xsc_id,drop index meter_id,drop index number;