I was talking to a customer this week about the process of generating a Change Script when they are ready to deploy their changes and they were concerned about the fact that the script generation always wants to drop and rebuild the object. They did not want to have to backup the data in the table and then restore it just to make a change to a table.
The way to do this is listed below:
"Sometimes it is necessary to drop an object (because of other dependencies), but in many cases Alter script can be generated instead of Drop and Create.
Check the Use Temporary Tables to Preserve Data option in the wizard:"
By using this option the table(s) will not be dropped and the data will be preserved.
I hope this helps someone else in the future.