Re: How do I know if a table exists?

may be you can use

CREATE OR REPLACE TABLE .... I've only tested this syntax with views,

"Robert H. Oujesky" wrote:
>
> I am running a script in SQLPlus. If the table exists, I want to drop it
> and then re-create it. I just don't know the syntax for checking the
> existance of a table....
>
> Thanx
Received on Fri Mar 22 2002 - 04:17:00 CST