Re: dictionary view for primary keys

From: Christopher Beck <clbeck_at_us.oracle.com>
Date: Wed, 13 Jan 1999 16:28:39 GMT
Message-ID: <369ec983.12676447@inet16.us.oracle.com>

On Wed, 13 Jan 1999 15:09:54 GMT, kal121_at_yahoo.com wrote:

>Hello,
>
>Is there a dictionary view I can query that will list the columns in a given
>table and their constraints - ie) primary key, foreign key, unique.
>
>I'm sure there is a view that has this info, but I can't find it.
>

look at dba_constraints.

hope this is what you are looking for.

chris.

>Thanks
>
>-----------== Posted via Deja News, The Discussion Network ==----------
>http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own

--
Christopher Beck
Oracle Corporation
clbeck_at_us.oracle.com
Reston, VA.

---

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Wed Jan 13 1999 - 10:28:39 CST