PRIMARY KEY-FOREIGN KEY 관계 찾기
=================================

PURPOSE
-------

이 자료는 MASTER TABLE CONSTRAINT 정보를 찾는 SQL이다.


Explanation
-----------

SCOTT의 EMP table의 Foreign Key와 부모 제약 조건을 찾으려면
다음의 질의문을 사용하여 찾을 수 있다.

SQL> alter table dept add constraint dept_pk primary key (deptno);

Table altered.

SQL> alter table emp add constraint emp_dept_fk foreign key(deptno)
references dept(deptno);

Table altered.

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;


foreign key referenced key C OWNER TABLE_NAME
-------------- --------------- --- ---------- -----------
EMP_DEPT_FK DEPT_PK P SCOTT DEPT


Example
-------
none


Reference Documents
-------------------