how can I determine the primary key for a table?
From: Larry W. Virden <lvirden_at_gmail.com>
Date: Mon, 30 Mar 2009 09:20:07 -0700 (PDT)
Message-ID: <4d5f2864-e34b-4049-9c2d-f0784ec42652_at_q2g2000vbr.googlegroups.com>
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:
Date: Mon, 30 Mar 2009 09:20:07 -0700 (PDT)
Message-ID: <4d5f2864-e34b-4049-9c2d-f0784ec42652_at_q2g2000vbr.googlegroups.com>
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