REPOST: Re: Test for a table

When not just use the direct approach?

SELECT COUNT(1)
FROM all_tables
WHERE table_name = ?

Or go one step better and use all_tab_columns to see if the table, and its columns, are there.

Personally I can't think of a single reason to ever test this. Just run your SQL in a block with an exception handler.

Daniel Morgan

TurkBear wrote:

> If the table is large that could take a long time; Try:
>
> select 'x' from table_name where 1=1 and rownum < 2;
>
> If it does exist, x will be returned..
> If the table does not exist, an error will result ( an ORA 942)...
> ( same as would happen in the other response)
>
> "Mark & Kristi Wagoner" <mwagoner_at_iac.net> wrote:
>
> >select count(*) from all_tables (or user_tables) where table_name='XXX';
> >
> >"Philip Morrow" <cracker_at_mymorrow.com> wrote in message
> >news:gn028.364520$oj3.71133325_at_typhoon.tampabay.rr.com...
> >> How can I test for the existance of a table using a SQL statement.
> >>
> >> Thanks
> >> Phil
> >>
> >>
> >
>
> -----= 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! ==-----

• WAS CANCELLED BY =======: From: "Daniel A. Morgan" <damorgan_at_exesolutions.com> Control: cancel <3C5131DC.5E6B6E29_at_exesolutions.com> Subject: cmsg cancel <3C5131DC.5E6B6E29_at_exesolutions.com> Date: Sun, 27 Jan 2002 23:49:38 GMT Message-ID: <cancel.3C5131DC.5E6B6E29_at_exesolutions.com> X-No-Archive: yes Newsgroups: microsoft.test,alt.flame.niggers,comp.databases.oracle.server NNTP-Posting-Host: w088.z064003087.lax-ca.dsl.cnc.net 64.3.87.88 Lines: 1 Path: news.uni-stuttgart.de!dns.phoenix-ag.de!newsfeed01.sul.t-online.de!t-online.de!newsfeed.media.kyoto-u.ac.jp!out.nntp.be!propagator-SanJose!in.nntp.be!news-in-sanjose!sjc-feed.news.verio.net!sea-feed.news.verio.net!news.verio.net!msrnewsc1!cppssbbsa01.microsoft.com!tkmsftngp01!tkmsftngp04!u&n&a&c&anceller Xref: news.uni-stuttgart.de control:40722478

This message was cancelled from within The Unacanceller's glorious new software, Lotus 1-2-3 For Rogue Cancellers. Received on Fri Jan 25 2002 - 04:22:20 CST