同创建索引一样,索引的删除常用的也是两种。
首先是drop index indexname on tablename:
drop index uniq_idx_exam_id on examination_info; drop index full_idx_tag on examination_info;第二种是使用alter table tablename drop index indexname:
alter table examination_info drop index uniq_idx_exam_id, drop index full_idx_tag;

京公网安备 11010502036488号