how can I determine the primary key for a table?

From: Larry W. Virden <>
Date: Mon, 30 Mar 2009 09:20:07 -0700 (PDT)
Message-ID: <>

I have a set of oracle tables which were set up by people no longer available for consultation.
When I select from the all_indexes table, asking about the index_name for one of my tables, it lists:

SQL> select index_name, uniqueness

        from all_indexes
        where table_name = 'TABLE_H'
        ;  2    3    4

INDEX_NAME                     UNIQUENES
------------------------------       ----------------
TABLE_H_PK                      UNIQUE

However, TABLE_H doesn't have a column called TABLE_H_PK .

How can I determine what column in TABLE_H is the primary key? Received on Mon Mar 30 2009 - 11:20:07 CDT

Original text of this message