题解 | #删除索引#
删除索引
http://www.nowcoder.com/practice/4963f6d63dde48d787aaa2b43460fb4b
两种做法:
1、drop
语法:DROP INDEX index_name ON tbl_name
drop index uniq_idx_exam_id on examination_info;
drop index full_idx_tag on examination_info;
2、alter
语法:alter tb_name drop index index_name
alter table examination_info
drop INDEX uniq_idx_exam_id;
alter table examination_info
drop INDEX full_idx_tag;