컴퓨터활용/오라클
PRIMARY KEY 생성하기
멜번초이
2003. 10. 12. 00:06
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);
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);