Re: Table listed by const/FK

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Wed, 12 Jun 2002 19:46:24 +0200
Message-ID: <ae89kd$4rk00$1@ID-62141.news.dfncis.de>

"deepred" <deepred_at_jumpy.it> wrote in message news:ae801c$4dj32$1_at_ID-51656.news.dfncis.de...
> Hi all.
> some one know how I can obtain a list of all the table of db/user order by
> constraint/FK dependencies ?
>
> I need this list to build a script to delete rows in all table according
> with FK rule.
> tnx
> R.
>
>
>

You'll need dba_constraints with constraint_type='R' The constraint it references is in r_owner, r_constraint_name, so to get a full overview you need to join the table to itself.

Hth

--
Sybrand Bakker
Senior Oracle DBA

to reply remove '-verwijderdit' from my e-mail address



>

>

Received on Wed Jun 12 2002 - 12:46:24 CDT