Alter Microsoft SQL Server 2008 Table in Design Mode

This article is not about sharing some programming ideas / concepts and some excellent code snippets. It's about sharing the necessary settings that you need to change to work in design mode simply as you did in Microsoft SQL Server 2008 because we can’t alter Microsoft SQL Server 2008 Object (design mode).

Image A

 

Solution Steps :

1- Open Microsoft SQL Server Management Studio 2008 ,Click on the tools menu and select Options.A window will appear with the various SQL Server settings options.

2- Select the Designers node and after that, click on the Tables and Database Designer sub node. Here you will find some option of a Table. The following image - B shows the general options of SQL Server database Table object.

Image B

3- You will find a checkbox (marked in orange color) named “Prevent saving changes that require table re-creation”. By default, the value of the checkbox is checked. You just need to uncheck the checkbox, that’s all.

Note: you can see this link for more info http://support.microsoft.com/kb/956176