Re: Newbie SQL question

From: Anne Hanson <ahanson_at_fas.harvard.edu>
Date: Thu, 23 Sep 1999 10:13:25 -0400
Message-ID: <37EA3585.8317A474@fas.harvard.edu>

michael_gressman_at_my-deja.com wrote:

> OK, I know that I can use DESC TableName to describe tables, but what if
> I don't know what the name of the table is? Is there an SQL query that
> will give me a list of the tables?

select table_name from dba_tables;

or, to narrow it down,

select table_name from dba_tables where owner = 'OWNERNAME';

>
>
> Thanks,
> Mike
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.
Received on Thu Sep 23 1999 - 09:13:25 CDT