title: Alter default value of column in mssql
body: <p>I need to alter the collation of quite a lot tables including all the columns of these tables. I already wrote a sql statement which generates these alter commands for me. So for example I get:</p>
  <pre><code>ALTER TABLE [TABLE] ALTER COLUMN [COLUMN] nchar(1  ) COLLATE Latin1_General_CI_AS not null default 'y'
  </code></pre>
  <p>However I get an error, regarding the default at the end. How can I incorporate the default constraint in the statement above?</p>
  <p>Thanks in advance.</p>