You need to be a premium member to use this feature. To access it, you'll have to upgrade your membership.
Become a sharper developer and jumpstart your career.
$0
$
. 00
monthly
For Basic members:
$20
For Premium members:
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.