Message-Id: <10561.112185@fatcity.com> From: Steven Monaghan Date: Mon, 17 Jul 2000 12:21:05 -0400 Subject: 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@fatcity.com [mailto:root@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@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@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)=