title: SQL convert all nullable columns to not nullable columns
body: <p>I got a database with 200 plus tables.</p>
  
  <p>Now I need a SQL script to find &amp; convert all "nullable Int" to "nonnullable Int" columns (assume database is empty).</p>
  
  <p>I know it can be done manually one by one</p>
  
  <pre><code>ALTER TABLE myTable 
  ALTER COLUMN myColumn {DataType} NOT NULL DEFAULT(0)
  </code></pre>
  
  <p>But I think there should be better way to do this, and it will be great help if you can suggest one.</p>