Re: Help: Sql query to get table names + descriptions

select table_name from all_tables where owner = xxxx will give you a list of tables.
all_tab_columns will give you a list of columns within a table. Other useful tables are:
all_segments, all_indexes (indexes), all_ind_columns (columns in index), all_views, all_synonyms.

--
Terry Dykstra [TeamPS]
Canadian Forest Oil Ltd.

Sooge wrote in message <70g063$f3m$1_at_hiram.io.com>...
>
>Greetings. I've been scanning the newsgroup and while I've
>seen similar posts haven't seen any answers. Apologies if I've
>missed something.
>
>Here's my problem: I want to be able to make straight SQL
>calls (not sql plus ie "describe") to get not only the available
>tables, but to also get a description of the tables.
>
>I've seen references to ALL_TABLES, and USER_TABLES, but haven't
>understood how to get at those, much less get a description
>of the table structure from them.
>
>I'm running Oracle 7.3.3 on solaris.
>
>Summary: How to I get a list of available tables?
> How do I get the table structure for a table (similar
> to SQLPlus "describe table_name")?
>
>Thanks,
>
>Sujay S.
>sks1_at_io.com
>
Received on Mon Oct 19 1998 - 14:11:19 CDT