You can remove a column, not just set it to NULL. Use the ALTER TABLE statement. Syntax:
ALTER TABLE [table] DROP COLUMN [columnlist] INSERT, DELETE, UPDATE are all built to change specific records. ALTER TABLE changes the structure of your table. Good luck. Ryan Duckworth Macromedia ColdFusion Certified Professional Uhlig Communications 10983 Granada Lane Overland Park, KS 66211 (913) 754-4272 -----Original Message----- From: Mark Drew [mailto:[EMAIL PROTECTED] Sent: Thursday, December 09, 2004 6:30 PM To: CF-Talk Subject: Re: Picky delete statement? Thats right. if you want to delete the columns of a record you have to update the record and set the columns to null or to whatever the default defined by the database e.g. Update mytable Set col1 = null , col2 = null Where id = <insert id> Hope that helps Regards Mark Drew On Thu, 9 Dec 2004 18:44:53 -0500, Phillip Perry <[EMAIL PROTECTED]> wrote: > Hi, > > I've read my sql book but I cant find what i'm looking for. According to the > book (as far as my understanding is) you cant specify which columns to > delete, you can only delete the whole record. Is this true? > > Phil > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:186981 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
