Re: foreign keys

From: <posani_at_hotmail.com>
Date: 1998/03/03
Message-ID: <6dim2h$5a9$1@nnrp1.dejanews.com>#1/1

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

suresh
In article <6dffcq$8dg$1_at_sloth.swcp.com>, elufker_at_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 Received on Tue Mar 03 1998 - 00:00:00 CST