Re: Foreign keys.

From: Mike Krolewski <mkrolewski_at_rii.com>
Date: Wed, 10 Jan 2001 21:46:25 GMT
Message-ID: <93il7d$iq5$1@nnrp1.deja.com>

In article <93ik5h$hod$1_at_nnrp1.deja.com>, vdolt_at_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_at_rii.com
              Usual disclaimers


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

Received on Wed Jan 10 2001 - 15:46:25 CST