Another way could be :
<cfquery ...>
DROP IF EXISTS TCustomers
</cfquery>
----- Original Message -----
From: "Joseph Thompson" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Saturday, December 16, 2000 2:20 AM
Subject: Re: SQL DROP TABLE
> How about the ever handy
>
> <cftry>
> Drop the table...
> <cfcatch>
> <!---Guess it ain't there--->
> </cfcatch>
> </cftry>
>
>
> > Problem:
> > If I run the DROP TABLE on a database where the table is already gone I
> get
> > a nasty SQL error.
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
