From: "Sybrand Bakker" <postbus@sybrandb.demon.nl>
Newsgroups: comp.databases.oracle.server
Subject: Re: Foreign keys.
Date: Tue, 10 Oct 2000 21:15:27 +0200
Message-ID: <971214678.2789.3.pluto.d4ee154e@news.demon.nl>
References: <8rvob0$i50$1@nnrp1.deja.com>
NNTP-Posting-Host: sybrandb.demon.nl
X-NNTP-Posting-Host: sybrandb.demon.nl:212.238.21.78
X-Trace: news.demon.nl 971214678 pluto:2789 NO-IDENT sybrandb.demon.nl:212.238.21.78
X-Complaints-To: abuse@nl.demon.net
X-Newsreader: Microsoft Outlook Express 5.00.3018.1300
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.3018.1300
Lines: 23


select r.table_name, r.constraint_name
from user_constraints c, user_constraints r
where c.table_name = '<your table>'
and   c.constraint_type='P'
and   r.referenced_name=c.constraint_name
and   r.referenced_owner=c.owner

Hth,

Sybrand Bakker, Oracle DBA


<vdolt@my-deja.com> wrote in message news:8rvob0$i50$1@nnrp1.deja.com...
> I am trying to delete a record from the table. Other tables have
> foreign keys on that table, which prevents me from deleting original
> record. Is there a query I can run to uncover all the foreign key on
> that table?
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.