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

From: Richard Farnworth <richard.farnworth_at_bt.internet.com>
Date: Mon, 19 Feb 2001 21:31:54 +0000
Message-ID: <3A9190CA.FB824EA0@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 Mon Feb 19 2001 - 15:31:54 CST