Saving a table change on SQL Server 2008

SQL Server 2008 Management Studio does not allow “saving” a table change, when it involves recreation. This is a good feture in general terms but may not be desired in a development environment. Here is how we can ask the designer to allow such changes.

Go to Tools > Options
And in the dialog below that opens, go to Designers > Table and Database Designers

Save Table Changes in SQL 2008

Leave a Reply

Your email address will not be published. Required fields are marked *