Re: Table Existence

Yeah,

IF you have the DBA privileges then you can check it out at DBA_TABLES (Pl. check for the correct syntax)

If you are a user then you can query the user_tables to find out about the existence of a table. I'm not quit sure that whether you would be able to see the Table names outside of your owner ships.

On Mon, 21 Feb 2000, Louis Frolio wrote:

> Is there a sql command in Oracle that will tell me whether or
> not a table exists? In T-SQL the command "IF EXISTS(..)" does
> just this. Any help would be appreciated.
>
> L
>
>
>

Sam .T

600 West 26Th Street,                 Phone : (512) 474-2328
Apartment #E 144,                     E-mail: sambavan_at_cs.utexas.edu
Austin,                                       sambavan_at_mail.utexas.edu
Texas - 78705.                                sambavan_at_tenet.edu




    -------------------------------------------------------
 
              What I do today is important because
              I'm exchanging a day of my life for it
                                           
    --------------------------------------------------------