FREE GUI tool http://www.websoft.com.au/downloads.html

From: Earl <earl_at_websoft.com.au>
Date: Fri, 11 Jan 2002 11:25:06 +1100
Message-ID: <3C3E30E2.68106D3E@websoft.com.au>

If its only "tables" you are after then: select table_name from all_tables where owner =<SCHEMA_NAME> If you later require other objects (eg. views,functions,procedures,triggers etc). then use select owner,object_type,object_name from all_objects where owner = <SCHEMA_NAME>

Also you can Download FREE a GUI tool called Platypus from http://www.websoft.com.au/downloads.html helps you manage/develop across many oracle databases/schemas simultaneously without typing in any sql:

* Create/Drop tables,indexes,primary key,views,triggers etc
* Monitor users connected to oracle databases
* Monitor/Add/Drop Users,Tablespaces,Datafiles

For those who like typing in sql it also includes: * SQL Windows with all results displayed in a spreadsheet style user interface. * SQL Scripts to run/save your batch files.

Philip Morrow wrote:

> What code can I run to determine if a table say 'tablea' exists in a schema
>
> Thanks
> Phil
Received on Thu Jan 10 2002 - 18:25:06 CST