Oracle 添加主键、索引、删除主键、索引

--删除表主键
ALTER TABLE jw_jxrw_wxlsrwkcb DROP CONSTRAINT PK_JW_JXRW_WXLSRWKCB;
--删除索引
drop index PK_JW_JXRW_WXLSRWKCB;

--添加主键-- Create/Recreate primaryalter table jw_jxrw_wxlsrwkcb add constraint PK_JW_JXRW_WXLSRWKCB primary key(WXLSRWKC_ID);--添加 索引-- Create/Recreate indexes create unique index PK_JW_JXRW_WXLSRWKCB on JW_JXRW_WXLSRWKCB (WXLSRWKC_ID)  tablespace ZF  pctfree 10  initrans 2  maxtrans 255  storage  (    initial 192K    next 1M    minextents 1    maxextents unlimited  );