From: posani@hotmail.com
Subject: Re: foreign keys
Date: 1998/03/03
Message-ID: <6dim2h$5a9$1@nnrp1.dejanews.com>#1/1
References: <6dffcq$8dg$1@sloth.swcp.com>
X-Originating-IP-Addr: 196.12.38.116
X-Http-User-Agent: Mozilla/4.03 [en] (WinNT; I)
Organization: Deja News - The Leader in Internet Discussion
X-Article-Creation-Date: Wed Mar 04 04:42:29 1998 GMT
Newsgroups: comp.databases.oracle.server



You can use user_constraints table to see all the constraints on all tables in
an user schema.

suresh
In article <6dffcq$8dg$1@sloth.swcp.com>,
  elufker@swcp.com (Ed Lufker) wrote:
>
> Hi All:
>
> 	What select statement would I use to see if there are any foreign
> keys on a table.
>
> thanks
> eddie lufker
>
>


-----== Posted via Deja News, The Leader in Internet Discussion ==-----
http://www.dejanews.com/   Now offering spam-free web-based newsreading