Re: newbie-desc command

"Me" <me_at_privacy.net> wrote in message
news:b1vccvgbffv5ro9n7qso72n8ilrhjfjdrm_at_4ax.com...
> In Oracle SQL* Plus desc command give the information of a table but
> how does one know which is the primary key?
>
> I am sorry if this has been already asked and answered here.
>
> Thanks in advance.
>

By querying
select constraint_name from user_constraints where table_name = '<your table>' and constraint_type = 'P'

There is a reference manual with a full break down of all the dictionary views. Please use it, before you come boring and will be ignored.

-- 
Sybrand Bakker
Senior Oracle DBA

to reply remove '-verwijderdit' from my e-mail address