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: [email protected] [mailto:[email protected]] On Behalf Of SAMARIS Software Sent: Monday, 18 May 2009 12:32 PM To: [email protected]; [email protected] 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 [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~----------~----~----~----~------~----~------~--~---
