Re: how do I list tables in a database?

Paul Mahler wrote:

> Can someone please tell me how I can use SQL, or some other tool, to
> list all the tables in a database?
>

Try:

    select * from dba_tables;

Also look at user_tables and all_tables for a more restricted view (schema based).

Steve Phelan. Received on Wed Jun 25 1997 - 00:00:00 CDT