Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: find out primary and foreign keys of a table

Re: find out primary and foreign keys of a table

From: Steffen Ramlow <s.ramlow_at_gmx.de>
Date: Wed, 20 Mar 2002 21:00:29 +0100
Message-ID: <a7apmu$jru58$1@ID-54600.news.dfncis.de>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US