RE: Foreign Key constraint Script

TOAD has a GUI schema browser that will tell you the constraint names=  and
the table/columns referenced. You can get it for free at www.toadsof= t.com

Steve Monaghan
WorldCom

(Not paid by or affiliated with Quest, just happen to love the produc= t!)

> -----Original Message-----
> From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of Ashish=
 Shah
> Sent: Monday, July 17, 2000 12:32 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Foreign Key constraint Script
>
>
> Hi All,
>
> Does any one have any script that will tell me
> a Table has been referenced (foreign key) in how many
> other tables. I had a tough time droping a table
> since
> it was refered by so many other table.
>
> I tried looking user_constraints but it doesn't give
> you information about primary table.
>
> TIA.
>
>
>
>
>
> =3D=3D=3D=3D=3D
> Ashish
> Toronto, Canada
>
> __________________________________________________
> Do You Yahoo!?
> Get Yahoo! Mail =96 Free email you can access from anywhere!
> http://mail.yahoo.com/
> --
> Author: Ashish Shah
> INET: ar_shah_at_yahoo.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Li=
sts
> -------------------------------------------------------------------=
-
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing)=
Received on Mon Jul 17 2000 - 11:21:05 CDT