Developement/DataBase
FK생성/삭제 스크립트
highheat
2006. 3. 30. 22:43
[문법]
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