Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: find out primary and foreign keys of a table
yapp, thx alot
"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message
news:lunh9u4onnerom6hdvm3tckq4pnumrseei_at_4ax.com...
> On Wed, 20 Mar 2002 18:49:19 +0100, "Steffen Ramlow" <s.ramlow_at_gmx.de>
> wrote:
>
> >which data dictionary views contain these informations?
> >
> user_|all_|dba_constraints
> user_|all_|dba_cons_columns
> constraint_type='P' primary key
> 'R' foreign key, the key it refers to is in
> r_constraint_name
>
> etc.
>
> Hth
>
> Sybrand Bakker, Senior Oracle DBA
>
> To reply remove -verwijderdit from my e-mail address
Received on Wed Mar 20 2002 - 14:00:29 CST
![]() |
![]() |