In SQL Server 2008 Management Studio,
We can not do
•Change the Allow Nulls setting for a column
•Reorder the columns
•Change the column data type
•Add a new column
How to fix / Resolution:
•Go to Tools -> Options -> Designers -> Tables and Designers
•Uncheck the Prevent Saving Changes that require table re-creation
1 comment:
I feel SQL is a very useful and powerful database management system that actually allows and looks into for more information about this.
SQL Server Load Rest API
Post a Comment