Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.tools -> Re: How to get a list of all the tables?
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...Received on Tue Feb 20 2001 - 03:28:11 CST
> 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/
>
![]() |
![]() |