Re: find out primary and foreign keys of a table

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Wed, 20 Mar 2002 20:17:07 +0100
Message-ID: <lunh9u4onnerom6hdvm3tckq4pnumrseei@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 - 13:17:07 CST