Re: Does a table exist
From: Sue Schoch <sue_at_iris.washington.edu>
Date: Thu, 10 Jan 2002 21:25:09 GMT
Message-ID: <3C3E06FE.ACCC75DB_at_iris.washington.edu>
Date: Thu, 10 Jan 2002 21:25:09 GMT
Message-ID: <3C3E06FE.ACCC75DB_at_iris.washington.edu>
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 - 22:25:09 CET