Re: How do I know if a table exists?

True, and that is what I am doing now. I just don't want users getting tense watching error messages scroll by. I am doing this for several tables and the user (Geologist, not computer literate...) is actually kicking this off automatically.

Thanx

"TurkBear" <jgreco1_at_mn.rr.com> wrote in message news:qr2k9uspmdn8lomi34bms69alk0a542r53_at_4ax.com...
>
> Unless you really need to know, just drop it..the error about the table
not existing will not stop your script..
>
>
> "Robert H. Oujesky" <roujesky_at_neuralog.com> 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
> >
>
>
>
> -----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
> http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
> Check out our new Unlimited Server. No Download or Time Limits!
> -----== Over 80,000 Newsgroups - 19 Different Servers! ==-----
Received on Thu Mar 21 2002 - 11:33:47 CST