Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Does a table exist
Philip Morrow wrote:
> What code can I run to determine if a table say 'tablea' exists in a schema
>
> Thanks
> Phil
select table_name from dba_tables where table_name = 'TABLEA' and owner = 'SCHEMA_NAME' ;
-- Sue Schoch mailto:sue_at_iris.washington.edu IRIS Data Management CenterReceived on Thu Jan 10 2002 - 15:25:09 CST