[PK 삭제 방법]
- ALTER TABLE EMP_TAB DROP PRIMARY KEY;
[PK 생성 방법]
- ALTER TABLE EMP_TAB ADD PRIMARY KEY (필드1, 필드2, 필드3));
- ALTER TABLE EMP_TAB ADD CONSTRAINT EMP_PK(PK이름) PRIMARY KEY (필드1, 필드2, 필드3));
[FK 삭제 방법]
- ALTER TABLE EMP1 DROP CONSTRAINT EMP1_FK;
[FK 생성 방법]
- ALTER TABLE EMP1 ADD CONSTRAINT EMP1_FK(FK이름) FOREIGN KEY(필드1, 필드2, 필드3)
REFERENCES EMP2(필드1, 필드2, 필드3);
[PK,FK 조회]
SQL> select c.constraint_name as "foreign key",
p.constraint_name as "referenced key",
p.constraint_type,
p.owner,
p.table_name
from dba_constraints c, dba_constraints p
where c.owner = 'SCOTT'
and c.table_name = 'EMP'
and c.constraint_type = 'R'
and c.r_owner = p.owner
and c.r_constraint_name = p.constraint_name;
