From: Mike Krolewski <mkrolewski@rii.com>
Newsgroups: comp.databases.oracle.server
Subject: Re: Foreign keys.
Date: Wed, 10 Jan 2001 21:46:25 GMT
Organization: Deja.com
Lines: 38
Message-ID: <93il7d$iq5$1@nnrp1.deja.com>
References: <93ik5h$hod$1@nnrp1.deja.com>
NNTP-Posting-Host: 63.75.139.178
X-Article-Creation-Date: Wed Jan 10 21:46:25 2001 GMT
X-Http-User-Agent: Mozilla/4.0 (compatible; MSIE 5.0; Windows NT; DigExt)
X-Http-Proxy: 1.1 x63.deja.com:80 (Squid/1.1.22) for client 63.75.139.178
X-MyDeja-Info: XMYDJUIDmikkrolewski


In article <93ik5h$hod$1@nnrp1.deja.com>,
  vdolt@my-deja.com wrote:
> Is there a way to find out all the foreign keys pointing to specific
> table? I am trying to drop it, and referential integrity won't let me.
> Thanks.
>
> Sent via Deja.com
> http://www.deja.com/
>

There are several choices:

Oracle's DBAStudio shows tables and constraints.

There are several views -->>
         all_cons_columns,
         all_constraints,
         user_cons_columns
         user_constraints
         dba_cons_columns,
         dba_constraints

should have the data. Look in the Oracle8i Reference, chapter 2 Static
Data Dictionary Views.

Many 3rd party tools like SQLProgrammer or TOAD or SQLNavigator will
display this information.


--
Michael Krolewski
Rosetta Inpharmatics
mkrolewski@rii.com
              Usual disclaimers


Sent via Deja.com
http://www.deja.com/