创建测试表

create table t1.t (a int,b varchar(200));

-- 添加主键、索引

alter table t1.t add primary key (a);alter table t1.t add index ind_t_a (a);

-- 删除主键、索引

alter table t1.t drop primary key;alter table t1.t drop index ind_t_a;