Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Foreign Key in Oracle Database
Type something like
select *
from dba_constraints
where CONSTRAINT_TYPE='R'
and elaborate on that is you need to find which PK it is refereing to by
self-joining it on R_CONSTRAINT_NAME column to itself.
Regards
"¤õª¢ª¢" <cwwong_at_se.cuhk.edu.hk> wrote in message
news:8lrj3e$fod$1_at_justice.csc.cuhk.edu.hk...
>
>
> Dear all,
> Would you like to tell me that how to find out a foreign keys of a table,
> which database table(s) I need to search?
>
> Thank you for your attention!
> Regards,
>
> Nelson Wong
> Research Assistant
> Systems Engineering & Engineering Management,
> CUHK
>
>
>
Received on Fri Jul 28 2000 - 00:00:00 CDT