Here you go... DELETE FROM (tabel name) Rayna Evans wrote: > > 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
