Re: finding the constraints referencing a table

select b.owner, b.table_name, b.constraint_name,

       b.r_constraint_name
from dba_constraints b, dba_constraints a

where b.r_owner = a.owner
  and b.r_constraint_name = a.constraint_name
  and a.owner = <owner of the referenced table>
  and a.table_name = <name of the referenced table>

--
Have a nice day
Michel


deniz <servermuratk_at_yahoo.com> a écrit dans le message : h07QZR7o$GA.218_at_news-02.uni.net...


> How can i find constraints referencing a table? Thanks in advance


>

>