title: "Prevent saving changes that require the table to be re-created" negative effects
body: <p><strong>Preamble</strong></p>
  
  <p>I was modifying a column in SQL Server 2008 today, changing the datatype from something like currency(18,0) to (19,2).  </p>
  
  <p>I got the error "The changes you have made require the following tables to be dropped and re-created" from SQL Server. </p>
  
  <p><strong>Before you scramble to answer, please read the following:</strong></p>
  
  <blockquote>
    <p>I already know there is the option in <strong>Tools ► Options ► Designer ► Table and Database Designers ► Uncheck the box</strong> "Prevent saving changes that require table re-creation."
    <a href="https://i.stack.imgur.com/NqKim.gif" rel="noreferrer"><img src="https://i.stack.imgur.com/NqKim.gif" alt="Prevent saving changes that require table re-creation in five clicks"></a>
    ...so <strong>do not</strong> answer with that!</p>
  </blockquote>
  
  <p><strong>Actual question</strong></p>
  
  <p>My actual question is for something else, as follows: </p>
  
  <p>Are there any negative effects / possible drawbacks of doing this? </p>
  
  <p>Does the table actually get dropped and recreated automatically when this box is unchecked?</p>
  
  <p>If so, is the table copy a 100% exact replica of the source table?</p>