title: In MSSQL, how do I add a column to a table of type "not null", if there is existing data in the table?
body: <p>If I attempt this in Microsoft SQL Server Management Studio, it gives an error if there is existing data in the table:</p>
  
  <blockquote>
    <p>Saving changes is not permitted. The changes you have made require the following tables to be dropped and re-created. You have either made changes to a table that can't be re-created or enabled the option Prevent saving changes that require the table to be re-created.</p>
  </blockquote>
  
  <p><img src="https://i.stack.imgur.com/Z19zJ.png" alt="enter image description here"></p>
  
  <p>Is it possible to do this manually without dropping the table?</p>