title: How to Update View in SQL Server 2005
body: <p>I want to update the existing view without dropping it, can you just provide me the syntax how to do it..?</p>
  
  <p><strong>Existing view:</strong></p>
  
  <pre><code>CREATE VIEW V1 AS SELECT EMP_ID,NAME FROM EMP_TABLE
  </code></pre>
  
  <p>I want to update V1 as:</p>
  
  <pre><code>SELECT EMP_ID,NAME, SALARY WHERE SALARY&gt;10000
  </code></pre>