Re: Get the primary key name of a table

From: Niall Litchfield <niall.litchfield_at_dial.pipex.com>
Date: Wed, 16 Mar 2005 20:30:47 -0000
Message-ID: <4238974d$0$10945$cc9e4d1f@news-text.dial.pipex.com>

"Robert Wehofer" <thalion77_at_graffiti.net> wrote in message news:kTYZd.2086$zY6.461_at_news.chello.at...
> Hello there!
>
> Which SELECT statement do I need to execute to get the primary key name of
> a
> certain table?

Hi Robert

you've asked a couple of data dictionary type questions now. I suggest that you have a look at the views named

USER_XXX
ALL_XXX
DBA_XXX Which describe the data dictionary in somewhat exhaustive detail. The concepts manual is pretty good too.

-- 
Niall Litchfield
Oracle DBA
http://www.niall.litchfield.dial.pipex.com

Received on Wed Mar 16 2005 - 14:30:47 CST