Geeks With Blogs
Robert Bernstein's Blog Adventures in Windows, .NET, and C++

By default, SQL Server Management Studio (SSMS) will not let you save changes to the designs of your tables.  When you attempt to do so, it wants you to drop and re-create the table.  You will typically see a dialog similar to the following:

Table Design Change Warning

However, SSMS will actually let you perform such a change without have to drop the table and re-create it.  To enable this feature, you need to select Tools / Options from the Menu.  Then, navigate to Designers / Table and Database Designers and uncheck the option to "Prevent saving changes that require table re-creation".

Enable Table Design Changes

Now click the OK button and try saving your table design changes.  Voila!

I owe a big thanks to my friend Jack for teaching me this trick.  It has saved me a lot of grief!

Posted on Monday, September 27, 2010 11:18 AM SQL | Back to top

Comments on this post: Enable SQL Server Mgmt Studio to Overwrite Table Designs

No comments posted yet.
Your comment:
 (will show your gravatar)

Copyright © Rob | Powered by: