FK생성/삭제 스크립트

[문법]

ALTER TABLE T_DETAIL
 ADD CONSTRAINT detail_FK
 FOREIGN KEY (ID)
REFERENCES T_MASTER (ID) ENABLE
VALIDATE

[사용예]

ALTER TABLE HANA_USER_ADDRESS
ADD CONSTRAINT USER_ADDRESS_FK
FOREIGN KEY (USER_ID)
REFERENCES HANA_USER (USER_ID) ENABLE
VALIDATE

[문법]

ALTER TABLE TABLE_NAME
 DROP CONSTRAINT FK_NAME

[사용예]

ALTER TABLE HANA_USER_ADDRESS 
DROP CONSTRAINT USER_ADDRESS_FK