Re: Question about tables

From: John Johnston <johnstoj_at_magicnet.net>
Date: 1997/10/28
Message-ID: <34554A3A.C55CD898@magicnet.net>#1/1

The following works only if privileges on the table have been granted to you or public.

Ed Jennings wrote:

> 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.com
Received on Tue Oct 28 1997 - 00:00:00 CST