Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Question about tables
select table_name
from all_tables
where table_name = 'TABLE_NAME_IN_QUESTION';
Haresh Assumal wrote:
>
> Is there any SQL command that a user can use to query if a certain table
> exists or not?
> -Haresh
> Email:assumal_at_sprynet.com
-- ~~~~~~~~~~~~~~~~~~~~~~~~~ jenningse_at_mindspring.comReceived on Mon Oct 27 1997 - 00:00:00 CST