Either of these two statements will remove the data from the table if you want to keep the table and it's structure: DELETE FROM table_name TRUNCATE TABLE table_name This statement will remove the table from the db: DROP TABLE table_name I wouldn't use the last one unless you are certain you won't need the table again, but I hope this helps:� Eric Gilbert Manager, Application Development StoneGround 560 Sutter Street, Suite 400 San Francisco, CA 94102 415.252.0600 (phone) 415.252.0123 (fax) http://www.stoneground.com/ CONFIDENTIALITY NOTICE: This message is intended only for the use of the individual or entity to which it is addressed, and may contain information that is privileged, confidential and exempt from disclosure under applicable law. All code Copyright �2001 StoneGround. All rights reserved. > -----Original Message----- > From: Rayna Evans [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, August 29, 2001 12: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
