title: Sql Server 'Saving changes is not permitted' error ► Prevent saving changes that require table re-creation
body: <p>When I create a table in SQL Server and save it, if I try to edit the table design, like change a column type from int to real, I get this error:</p>
  
  <blockquote>
    <p>Saving changes is not permitted. The change you have made requires the following table to be dropped and re-created. You have either made changes to a table that can't be recreated or enabled the option prevent saving changes that require the table to be re-created.</p>
  </blockquote>
  
  <p>Why do I have to re-create the table? I just want to change a data type from <code>smallint</code> to <code>real</code>.</p>
  
  <p>The table is empty, and I didn't use it until now.</p>