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?
select * from user_tables -> all tables belonging to the user select * from all_tables _> all tables the user can see select * from dba_tables -> all tables
-- Our new email address is kennedy-family_at_home.com . "Babylon5Fan" <alweiner_at_my-deja.com> wrote in message news:967ggo$14k$1_at_nnrp1.deja.com...Received on Sun Feb 11 2001 - 20:47:14 CST
> 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/