delete from YourTableNameHere (where whatever conditions are met) you don't HAVE to use a 'where' clause on your delete, and apparently it doesn't matter if you don't in this specific case, but it can be *really* dangerous not to use it on 'real' data (i'm sure everyone here can attest to an accidental delete without a where clause at some point - i know i can). -----Original Message----- From: Rayna Evans [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 29, 2001 3:36 PM To: CF-Talk Subject: SQL I am trying to clear some data out of a table i created which is used in a CF application I am developing. I don't want the data in the table anymore (it's a development table so no harm if I delete the data). I know the SQL statement is Truncate to delete the data and not the table, but I can't figure out what the statement is or how it should be correctly worded. Any help would be greatly appreciated. Thanks, Rayna Rayna Evans AAMC 2501 M Street, 2nd Fl Washington, DC 20037 202-862-6243 (direct) Extension 4243 (internal) ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
