Re: how to see what tables exist?
From: Satheesh Babu <vze3myxh_at_verizon.net>
Date: Fri, 12 Jul 2002 10:58:27 GMT
Message-ID: <pan.2002.07.12.10.58.50.509243.2117_at_verizon.net>
Date: Fri, 12 Jul 2002 10:58:27 GMT
Message-ID: <pan.2002.07.12.10.58.50.509243.2117_at_verizon.net>
On Fri, 12 Jul 2002 05:55:51 -0400, Christopher Pisz wrote:
> Is there a sql statement to see what tables exist in a db? I can
> describe tables once I have thier name, but how do you describe the db?
> Thanx,
> Christopher
select * from all_tables
select * from user_tables (for listing tables owned by user)
See for views/tables named all_* in the data dictionary Received on Fri Jul 12 2002 - 12:58:27 CEST