Re: Prymary Key

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: 2000/03/23
Message-ID: <953851537.19001.2.pluto.d4ee154e@news.demon.nl>#1/1

select table_name, constraint_name
from user_constraints
where constraint_type = 'P'

Hth,

Sybrand Bakker, Oracle DBA

Riccardo D.S. <rdistefano_at_aleniasystems.finmeccanica.it> wrote in message news:38D9F98B.3C791748_at_aleniasystems.finmeccanica.it...
> Is it possible to know the name of the Primary Keys present in
> a particular table using User or System table?
>
> Riccardo Di Stefano
>
>
>
Received on Thu Mar 23 2000 - 00:00:00 CST