sql-serverssmsssms-16

“Prevent saving changes that require the table to be re-created” Microsoft SQL Server

I was modifying a column in SQL Server 2016 Management Studio (SSMS) and got the error:

The changes you have made require the following tables to be dropped and re-created

I'm testing and so I don't have any problem with dropping and re-creating new tables. Where is the option to disable this error?

Solution

  • Tools --> Options --> Designers --> Table and Database Designers

    In here you will find the following checked option:

    Prevent saving changes that require table re-creation

    Just uncheck it!