Thanks for your reply Regards Claude Raiola SAMARIS.net Software Email: i...@samaris.net Mobile 0414 228 948 Website: www.SAMARIS.net
-----Original Message----- From: "Steve Onnis" <st...@cfcentral.com.au> Date: Mon, 18 May 2009 12:41:15 To: <cfaussie@googlegroups.com> Subject: [cfaussie] Re: Adding Extra Column To SQL Database Claude Before you do anything, make sure you back up the database. To answer your question, it should just add the column in. Depending on how complex the table change is, sometimes it created a tmp table, puts the data in there, drops the table, re-creates the table with the changes and adds the data back in. In anycase you should not loose the data. The only reason why you may sometimes loose data is if you are changing the column types of a column. Steve _____ From: cfaussie@googlegroups.com [mailto:cfaus...@googlegroups.com] On Behalf Of SAMARIS Software Sent: Monday, 18 May 2009 12:32 PM To: cfaussie@googlegroups.com; coldfusion-ho...@yahoogroups.com Subject: [cfaussie] Adding Extra Column To SQL Database I am using SQL Server Manager to add an extra collum to an existing database table and when I proceed to save the changes I receive a message telling me the table I am editing is about to be saved to the database even though it already exists and has many thousand records contained within it I have never come across this before so I am not sure if it is simply telling me its saving the change to the table structure or is it going to do overwrite my existing table which clearly I do not want it to do if this will cause me to loose my existing data. Regards Claude Raiola B.Econ (Acc), B.Hot.Mngt. Websites: www.AustralianAccommodation.com www.SAMARIS.NET www.WebSiteSolutions.com.au Mobile: 0414 228 948 ---~----~----~------~----~------~--~--- --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~----------~----~----~----~------~----~------~--~---
