title: Is it possible to change the datatype of a column in a view?
body: <p>Usually I run a script like this: </p>
  
  <pre><code>ALTER TABLE [TABLE]
  ALTER COLUMN [Column] NVARCHAR(40);
  </code></pre>
  
  <p>The result is that the field in the table gets converted to nvarchar. But what is the syntax for doing the same thing for a view? Or is that even possible?</p>