
Go to Tools – Then Click on Options,

Then click on Designers – Then untick prevent saving changes that require table re-creation.
And click Ok.

Now it will allow you to make changes to your tables that require table recreation.
In this blog you will learn how to enable table recreation in SQL Server.
Join the conversation! Your thoughts help the community grow.
Sign in to leave a comment
It is the same account you read, post and publish with — and you will come straight back to this page.

Go to Tools – Then Click on Options,

Then click on Designers – Then untick prevent saving changes that require table re-creation.
And click Ok.

Now it will allow you to make changes to your tables that require table recreation.
kalu singh raoPosted Jul 27, 2016, 1:53 AM
Nice share