PRIMARY KEY 생성하기

ALTER TABLE xxxx ADD (CONSTRAINT xxxx_PK PRIMARY KEY(PHYNO)
USING INDEX TABLESPACE IDX_TBS STORAGE(INITIAL 50K
NEXT 5K PCTINCREASE 0 MINEXTENTS 10 MAXEXTENTS UNLIMITED));

확인

select table_name , constraint_name , constraint_type from all_constraints
where table_name = 'BBTB_CNT'

날리기

ALTER TABLE bbtb_cnt drop CONSTRAINT SYS_C001193 ;

또는

alter table bbtb_cnt add primary key (bbsno, phyno);