RE: SQL query

        I am sorry for not being precise in my question. I would like to view the primary key, foreign key and other 'constraints' information of my table. While this could be viewed with 'desc' in other dbmss, this information is not provided with the 'desc' in oracle. With what command can I view it in Oracle?

On Fri, 12 Jul 2002, Abdul Aleem wrote:

> At SQL*Plus it is the same command
> Describe or desc and name of the table
>
> You also need to be connected to the database
>
> HTH
> Aleem
> -----Original Message-----
> Sent: Saturday, July 13, 2002 11:53 AM
> To: Multiple recipients of list ORACLE-L
> Subject: SQL query
>
>
> I am using an Oracle database running in Linux. I would like to
> view the description of a table. For ex., if there is a table called
> 'person'. I would like to see the names of the columns in this table,
> their datatypes and such other details. In other dbmss like mysql a
> command 'describe <tablename>' gives the information. What is the
> equivalent in Oracle?
>
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Vandana
  INET: vandana_at_gdit.iiit.net

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).