title: SQL Server - changing definition of column that appears in multi tables
body: <p>many of tables in my DB have a Boolean column 'IsDeleted'.</p>
  
  <p>I need to alter the column in all tables, that the default value will be zero, and then update all old records with value null, to be with value zero.</p>
  
  <p>There is a way to do it beside writing a script for every table?</p>
  
  <p>Thanks,</p>