Don't know about the truncate thing, but this should delete all rows leaving you with an empty table: DELETE FROM TABLE_NAME ----- Original Message ----- From: Rayna Evans To: CF-Talk Sent: Wednesday, August 29, 2001 2:35 PM 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
