SQL Server Management Studio Tips - How to activate saving table modifications

less than 1 minute read

Once you have created a table using Sql Server Management Studio, you have done changes the table structure, you want to save it.

But SSMS doesn’t allow you to do so.

You need to modify the configuration in Tools -> Options -> Designers and uncheck “Prevent saving changes that require table re-creation”.

I hope this post can do help to you!

SUN Jiangong

SUN Jiangong

A senior .NET engineer, software craftsman. Passionate about new technologies.