Re: Newbie question: How to check for a tables existence in a smart (fast) way ??

If Exists ( select * from sysobjects where id=object_id('dbo.<tablename>') and sysstat & oxf = 3) <response query here if it does exist>

-Mike
(Remove end "x" to send email)

õ¸®¾È NEWS GROUP ÀÌ¿ëÀÚ wrote:
>
> Brad Murray (BradMurray_at_SeeSignatureIfThere.com) wrote:
> : [This followup was posted to comp.databases.oracle.misc and a copy was sent
> : to the cited author.]
 

> : In article <6935n9$nrp_at_info.telenor.no>, jorgen.hauikland_at_fou.telenor.no
> : said...
> :
> : > I'm working on an application and need to create some tables if they don't
> : > already exists - sometimes they do. I've tried to find a smart SQL statement
> : > but i end up with something that lists smaller or larger parts of the table.
> : > This is no good solution because this table can occasionally be quite large
> : > (50 - 60 MB). I need a statement that don't do any searching in the table,
> : > just sees if it's there.
 

> : Just search for its existence in the Accessible_Columns view.
> : _______________________________________________________________________
> : Bradley S. Murray Princeton Computer Consulting (609) 730-9100
> : BradMurray(-at-)usa.net Pennington, NJ 08534-3612 Fax: 275-5651
  Received on Mon Jan 12 1998 - 00:00:00 CST