Re: finding a table's primary key

From: <yewpc_at_my-dejanews.com>
Date: Wed, 03 Mar 1999 03:28:21 GMT
Message-ID: <7bia8d$34s$1@nnrp1.dejanews.com>

DBA_INDEXES, USER_INDEXES or ALL_INDEXES enable you to see table's indexes which include primary key. DBA_IND_COLUMNS, USER_IND_COLUMNS or ALL_IND_COLUMNS enable you to see which column is used as indexe.

In article <7bgijs$i1e$1_at_nnrp1.dejanews.com>, jerwynn_at_buyasia.com wrote:
> Is there an SQL or PL/SQL command to query the primary key of a table?
>
> If not, where (in which tables) can I find information
> about the primary keys of tables?
>
> Thanks.
>
> Jerwynn
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Tue Mar 02 1999 - 21:28:21 CST