Re: What does a table look like?

tkyte_at_us.oracle.com (Thomas J Kyte) wrote:

> desc TABLE_NAME works as well.
 

> For example
 

> SQL> desc all_users
> Name Null? Type
> ------------------------------- -------- ----
> USERNAME NOT NULL VARCHAR2(30)
> USER_ID NOT NULL NUMBER
> CREATED NOT NULL DATE
>
> SQL>
If you want to get more specific then try

   DESC tablename columnname

(very helpful for HUGE tables)

> enduser_at_enduser.com (EndUser) wrote:
 

> >log on as system/manager, select * from tab, gets all tables.
> >select * from syscolumns where tabname = 'xxx' gets you columns.
> >look in the back of your dba ref to see all system views, else, you
> >can see the list of views as they spill out of the system/manager tab
> >select.
 

> >--
 

> >In article <49cqgc$hcp_at_ams.amsinc.com>, joel_nylund_at_mail.amsinc.com (Joel
> >Nylund) wrote:
 

> >> I am new to oracle, I need to find out what the schema of a table looks
> >>
> >> like. In sybase I can do a "sp_help" which gives all of the column names
> >>
> >> and their attributes.
> >>
> >> Is there an easy way to do this in oracle?
> >>
> >>
> >> thanks in advance
> >> Joel
 

> Thomas Kyte
> tkyte_at_us.oracle.com
> Oracle Government

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

Chris Kasten
Programmer/Analyst (among others...)

#include <sys/std_disclaimer.h>

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- Received on Tue Nov 28 1995 - 00:00:00 CET