• In my experience, SSMS does not script a drop and recreate of a table unless you insert the new column somewhere other than at the end. To append a new column doesn't recreate the table. I know this because I always have the save change script option active so I know what is going to happen before I commit the changes.