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
Jim
--
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...
> 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 Sun Feb 11 2001 - 20:47:14 CST
