Re: to check if a table exists

From: Douglas Hawthorne <>
Date: Mon, 12 Apr 2004 06:16:51 GMT
Message-ID: <nvqec.5212$>

"DottingTheNet" <> wrote in message
> i promise no more silly questions after this
> but how do i check if a table exists??
> it is my understanding that the exists can only be used in the where
> clause of the query.
> i just want s'thing simple like
> if exists ('test')
> then ---good
> else
> --create it
> end if;
> thanx in advance!!!

Check out the ALL_TABLES and USER_TABLES views in the "Database Reference" manual.

Douglas Hawthorne Received on Mon Apr 12 2004 - 08:16:51 CEST

Original text of this message