Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: dictionary view for primary keys
In article <369ec983.12676447_at_inet16.us.oracle.com>, clbeck_at_us.oracle.com wrote:
>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.
.. and sys.dba_cons_columns (or user_cons_columns or ...)