SSMS - Enable Table Recreation

In this blog you will learn how to enable table recreation in SQL Server.

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.