How to modify table once its created in sql server 2012?

Question

I m trying to modify table its give me the following error:

enter image description here

There is no data in this table.

score 3 · Accepted Answer · answered Aug 15 '13 at 12:41

There is a SSMS option that governs this behaviour:

Tools -> Options -> Designer -> Uncheck "Prevent saving changes that require table re-creation"

IMHO, It's bizarre that this option is enabled by default, even more so when the SSMS Designer uses drop and re-create for some things that do not need it (i.e. changing the nullability of a column)

How to modify table once its created in sql server 2012?

1 Answers1