题解 | #删除索引#
删除索引
https://www.nowcoder.com/practice/4963f6d63dde48d787aaa2b43460fb4b
同创建索引一样,索引的删除常用的也是两种。
首先是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;

