정상혁의 수첩 benelog

Sybase key constraint 더하기

Edit

ALTER TABLE CM_MAINCD ADD CONSTRAINT CM_MAINCD_PK
PRIMARY KEY ( MAIN_CD )

ALTER TABLE CMMAIN_CD ADD CONSTRAINT CM_SUBCD_FK01
FOREIGN KEY ( MAIN_CD )
REFERENCES CM_MAINCD ( MAIN_CD)

Last edited on 07/05/2007 15:58 by benelog

Previous Next

All Pages