Re: Primary Key

From: Howard J. Rogers <dba_at_hjrdba.com>
Date: Tue, 12 Mar 2002 19:52:22 +1100
Message-ID: <a6kfkn$ifg$1@lust.ihug.co.nz>

Have a look at DBA_CONSTRAINTS (or ALL_CONSTRAINTS).

Select * from all_constraints where table_name='EMP'; would do it.

To find out which columns are part of the constraint, select * from all_cons_columns where table_name='EMP';

Regards
HJR

--
----------------------------------------------
Resources for Oracle: http://www.hjrdba.com
===============================


"Kram" <myoung_at_optushome.com.au> wrote in message
news:Qwgj8.35$an4.4277_at_nsw.nnrp.telstra.net...


> How do I find the primary key of a table?

>

>

Received on Tue Mar 12 2002 - 02:52:22 CST