Sql-server – “Prevent saving changes that require the table to be re-created” negative effects

database-designsql serversql-server-2005sql-server-2008

Preamble

I was modifying a column in SQL Server 2008 today, changing the datatype from something like currency(18,0) to (19,2).

I got the error "The changes you have made require the following tables to be dropped and re-created" from SQL Server.

Before you scramble to answer, please read the following:

I already know there is the option in Tools ► Options ► Designer ► Table and Database Designers ► Uncheck the box "Prevent saving changes that require table re-creation."
Prevent saving changes that require table re-creation in five clicks
…so do not answer with that!

Actual question

My actual question is for something else, as follows:

Are there any negative effects / possible drawbacks of doing this?

Does the table actually get dropped and recreated automatically when this box is unchecked?

If so, is the table copy a 100% exact replica of the source table?

Best Answer

Tools --> Options --> Designers node --> Uncheck " Prevent saving changes that require table recreation ".