title: Alter column, add default constraint
body: <p>I have  a table and one of the columns is "Date" of type datetime. We decided to add a default constraint to that column</p>
  
  <pre><code>Alter table TableName
  alter column dbo.TableName.Date default getutcdate() 
  </code></pre>
  
  <p>but this gives me error:</p>
  
  <blockquote>
    <p>Incorrect syntax near '.'</p>
  </blockquote>
  
  <p>Does anyone see anything obviously wrong here, which I am missing (other than having a better name for the column)</p>