I am trying to use cfquery to drop a table. That works fine.\

Problem:
If I run the DROP TABLE on a database where the table is already gone I get
a nasty SQL error. Is there a simple way to check for the existance of the
table, and if present, then drop it? My mind is mush right now and I cannot
figure this one out. Thank all.

Regards,

Gary McNeel, Jr.
DACNet Project Manager
Research and Graduate Studies
Rice University
[OP] 713-348-6266
[M] 713-962-0885
[HO] 713-723-9240


~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
        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

Reply via email to