摘要： 1.删除主键alter table ACC6 drop CONSTRAINT SYS_C0015557[主键名]如果是alter table ACC6 drop primary key(aae002,aac001,aae140,aab001)这在oracle执行是会出错的2.增加主键ALTER TABLE supplieradd CONSTRAINT constr_pk[主键名] PRIMARY KEY (supplier_id[列名]);如alter table ACC6 add CONSTRAINT constr_acc6 primary key(aae002,aac001,aae140, 阅读全文