DB2 사용중인 테이블에 primary key 추가
ALTER TABLE SO_SELL_ETC DROP PRIMARY KEY;
ALTER TABLE SO_SELL_ETC
ADD CONSTRAINT "P_SO_SELL_ETC" PRIMARY KEY (NAT_CD,PLNT_CD,VND_CD,IO_YMD,IO_KND,IO_TYP,ACT_TYP,ACT_CD);
ALTER TABLE SO_SELL_ETC
ADD CONSTRAINT "P_SO_SELL_ETC" PRIMARY KEY (NAT_CD,PLNT_CD,VND_CD,IO_YMD,IO_KND,IO_TYP,ACT_TYP,ACT_CD);
댓글
댓글 쓰기