Re: How to get a list of all the tables?

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Tue, 20 Feb 2001 09:28:11 -0000
Message-ID: <96tdbd$onh$1@soap.pipex.net>

This won't work. perhaps you meant where object_TYPE='TABLE' ?

alternatively select * from user_tables; and select * from user_tab_columns; might be more along the lines the poster wants

--
Niall Litchfield
Oracle DBA
Audit Commission UK
"Richard Farnworth" <richard.farnworth_at_bt.internet.com> wrote in message
news:3A9190CA.FB824EA0_at_bt.internet.com...


> select * from user_objects where object_name = 'TABLE' is a good start ..

> works with INDEX etc.

>

> Do this in a user ID you only get the tables relating to that Schema

> Do it from a DBA account and substitute user for ALL and you will get

 every


> table including the system SYS$ tables.

>

>

> Babylon5Fan wrote:

>

> > I know you can use the sql stmt: describe table

> > where table is the name of a table in the tablespace. However, is there

> > a sql stmt to give a list of all the tables?

> >

> > Sent via Deja.com

> > http://www.deja.com/

>

Received on Tue Feb 20 2001 - 03:28:11 CST