title: sql server how to add a column to a view
body: <p>A view is created use the following sql:</p>
  
  <pre><code>create view [dbo].[tblDimSession] AS 
      SELECT * 
      FROM OPENQUERY(CDH_DEV_BJ_LS, 'select * from Session') 
  </code></pre>
  
  <p>This view is created by accessing data with Hive.</p>
  
  <p>I want to add a new column named <code>sessionID</code>, <code>int</code> type, must be an auto-increased column.</p>
  
  <p>How to alter the view, or could the column be added when creating the view?</p>
  
  <p>Thank you.</p>