Oracle添加删除主键、索引 DDL -- 删除表 EMPLOYEE 主键 PK_EMPLOYEE alter table EMPLOYEE drop constraint PK_EMPLOYEE; -- 删除索引 IDX_EMPLOYEE drop index IDX_EMPLOYEE; -- 添加主键 alter table EMPLOYEE add constraint PK_EMPLOYEE primary key (ID); -- 添加索引 create unique index IDX_EMPLOYEE on EMPLOYEE (ID);