Re: newbie-desc command

From: Me <me_at_privacy.net>
Date: Sun, 18 May 2003 15:23:19 +0530
Message-ID: <fdlecv8rlgbteg78k6nfa7c3m4nq9em6t8@4ax.com>

On Sat, 17 May 2003 22:17:20 +0200, Sybrand Bakker wrote:

:
:"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.

Thanks to you and Rauf Sarwar
sorry for asking this.

Can I ask such questions by mail if you don't mind? Received on Sun May 18 2003 - 04:53:19 CDT