title: Incorrect syntax near the keyword 'DEFAULT' in SQL Server
body: <p>I prepared below script to drop default value column.</p>
  <pre><code>ALTER TABLE [TableName] 
  ALTER COLUMN [ColumnName] DROP DEFAULT;
  </code></pre>
  <p>But It has following error</p>
  <blockquote>
  <p>Msg 156, Level 15, State 1, Line 3
  Incorrect syntax near the keyword 'DEFAULT'.</p>
  </blockquote>