Re: how to view all of a specific table's relationship to other tables..

From: Roman Mirzaitov <rmirzaitov_at_kt.kg>
Date: Tue, 11 Mar 2003 11:00:51 +0500
Message-ID: <b4ju2u$20cpeq$1@ID-127142.news.dfncis.de>

Hi,

select c.constraint_name, c.constraint_type, r.table_name referencing_table from all_constraints c, all_constraints r where c.r_constraint_name=r.constraint_name

and c.owner=r.owner
and c.table_name = <TABLE NAME>
and c.owner = <TABLE OWNER>

Regards,

--
Roman Mirzaitov
Brainbench MVP for Oracle Administration
www.brainbench.com

"AMY" <oracleapple_at_yahoo.com> wrote in message
news:8c698c2f.0303101926.6e0d641c_at_posting.google.com...


> i have a 'Employee' Table and want to know how to view the relation of

> this 'employee' table to other table.

Received on Tue Mar 11 2003 - 00:00:51 CST