Oracle 更改表主键
1.先删除主键
alter table T_SF_SUPPLIER drop constraint PK_T_SF_SUPPLIER;
2.增加主键
alter table T_SF_SUPPLIER
add constraint PK_T_SF_SUPPLIER primary key (sp_id)
using index
tablespace SYSTEM
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);