oracle drop primary key (转)

1.删除主键

alter table ACC6 drop CONSTRAINT SYS_C0015557[主键名]

如果是alter table ACC6 drop primary key(aae002,aac001,aae140,aab001)

这在oracle执行是会出错的

2.增加主键

ALTER TABLE supplier
add CONSTRAINT constr_pk[主键名] PRIMARY KEY (supplier_id[列名]);

如alter table ACC6 add CONSTRAINT constr_acc6 primary key(aae002,aac001,aae140,aab001)