Re: What does a table look like?

From: EndUser <enduser_at_enduser.com>
Date: 1995/11/27
Message-ID: <enduser-2711951100350001_at_dial-cup1-9.iway.aimnet.com>#1/1


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
Received on Mon Nov 27 1995 - 00:00:00 CET

Original text of this message