oj-sql

题目

SQL122 删除索引

思路

1. drop index;
2. 也可以使用alter语句修改表结构；

solution

drop index

drop index uniq_idx_exam_id on examination_info;
drop index full_idx_tag on examination_info;

alter table examination_info drop index uniq_idx_exam_id;
alter table examination_info drop index full_idx_tag;