title: T-SQL: Alter View
body: <p>I have a view with a field for date as a varchar. I need to change it to date time using the following code</p>
  
  <pre><code>    CONVERT(DATETIME, MyDates)
  </code></pre>
  
  <p>This works fine when executing the view but I want to make the change permanent. I need some help with the syntax. So far I have</p>
  
  <pre><code>    ALTER VIEW tableName
      CONVERT(DATETIME, MyDates)
  </code></pre>
  
  <p>but it's obviously not working</p>