sql server - "Prevent saving changes that require the table to be re-created" negative effects

Question

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 1

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