PRIMARY KEY 재생성 방법 Tip

1. PRIMARY KEY DROP

  alter table <tablename> drop primary key;

 
  Example :
  alter table EMP drop primary key;

 

2. PRIMARY KEY 생성

 alter table <tablename> add constraint <primary key name> primary key(<primary key column list>)
    using index storage(initial 1m next 1m pctincrease 0)
    tablespace <tablespace name>;
      
      
  Example :
   alter table EMP add constraint EMP_PK primary key(EMPNO)
 using index storage(initial 1m next 1m pctincrease 0)
 tablespace USERS;