"Prevent saving changes that require the table to be re-created" negative effects
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."
...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?
Answer
Tools --> Options --> Designers node --> Uncheck " Prevent saving changes that require table recreation ".