You sir, are a hero, a true hero of the revolution
On Thu, 24 Aug 2000, Andy Ewings spake thusly:
> Yup....if you are using SQL server the syntax is.....
>
>
> IF EXISTS (SELECT * FROM sysobjects WHERE name = "<tablename>" AND type =
> "U")
> BEGIN
> PRINT "Table Exists!."
> END
>
>
> -----Original Message-----
> From: Jon Tillman [mailto:[EMAIL PROTECTED]]
> Sent: 24 August 2000 11:09
> To: [EMAIL PROTECTED]
> Subject: checking for tables?
>
>
> quick question:
> is there any way to check to see if a table exists without querying it, and
> throwing an error if it does not? I want to either CREATE or INSERT a table
> depending on whether or not it already exists....
>
> --
> ***********************************************
> Jon Tillman
> LINUX USER: #141163
> ICQ: 4015362
> http://www.eruditum.org
> [EMAIL PROTECTED]
> ***********************************************
> Help Jon build a network!
> Looking for giveaway computers & parts
> Current Need: Tape Drive & PI/PII processors
> Email me to find out how you can help
> ***********************************************
>
> ----------------------------------------------------------------------------
> --
> Archives: http://www.mail-archive.com/[email protected]/
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
> ------------------------------------------------------------------------------
> Archives: http://www.mail-archive.com/[email protected]/
> To Unsubscribe visit
>http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
>message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
--
***********************************************
Jon Tillman
LINUX USER: #141163
ICQ: 4015362
http://www.eruditum.org
[EMAIL PROTECTED]
***********************************************
Help Jon build a network!
Looking for giveaway computers & parts
Current Need: Tape Drive & PI/PII processors
Email me to find out how you can help
***********************************************
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
