Orcale 9i primary and foerign key constraint
719911Oct 5 2009 — edited Oct 5 2009I had created table in the following way
create table dept(deptno number,dname varchar2(20));
create table emp(empno number primary key,ename varchar2(25), deptno number references dept(deptno));
One can get constraint name and constraint type from user_constraints table. But I want to know name of the column of table from which column is used as foreign key in another table. How to get such information?