ALTER 문법

 

 

ALTER 문법으로 PK 설정 

 

ALTER TABLE 테이블명 ADD CONSTRAINT PK_테이블명 PRIMARY KEY(컬럼명);

▼

ALTER TABLE lms_room_photo ADD CONSTRAINT PK_lms_room_photo PRIMARY KEY(rpno);

---

ALTER 문법으로 FK 설정

ALTER TABLE 테이블명 ADD 
        CONSTRAINT FK_테이블명2 
        FOREIGN KEY(테이블명2 컬럼명)REFERENCES 참조할 테이블1(참조할 컬럼명);

▼

ALTER TABLE lms_room_photo ADD 
        CONSTRAINT FK_lms_room_photo 
        FOREIGN KEY(rpno)REFERENCES lms_room(rno);

---

PK/FK 조회하기

 

SELECT * FROM ALL_CONSTRAINTS 
WHERE TABLE_NAME = '테이블명';

▼

SELECT * FROM ALL_CONSTRAINTS 
WHERE TABLE_NAME = 'LMS_ROOM_PHOTO';

---

PK/FK 삭제하기

 

 

ALTER TABLE 테이블명 DROP CONSTRAINT FK_테이블명;

▼

ALTER TABLE LMS_ROOM_PHOTO DROP CONSTRAINT FK_LMS_ROOM_PHOTO;