How to find primary Key & alternate key of a Oracle Table

Friday, November 1, 2013

How to find primary Key & alternate key of a Oracle Table

How to find primary Key & alternate key of a Oracle Table

SELECT   a.table_owner, table_name, index_name, column_name
    FROM dba_ind_columns a
   WHERE a.table_owner = 'TABLE_OWNER' AND table_name = 'TABLE_NAME'
ORDER BY a.table_owner, table_name, column_name  

*** Identify the primary/alternate keys based on index names  

Error 404

The page you were looking for, could not be found. You may have typed the address incorrectly or you may have used an outdated link.

Go to Homepage