title: sql server modify error
body: <p>i m not able to modify table in SQL server. i m new to databases.  </p>
  
  <pre><code>use work 
  go 
  alter table employee 
  modify id varchar(20) 
  </code></pre>
  
  <p>error message is- </p>
  
  <pre><code>Msg 102, Level 15, State 1, Line 1 
  Incorrect syntax near 'modify'
  </code></pre>
  
  <p><a href="http://img638.imageshack.us/img638/7886/sqlr.jpg" rel="nofollow noreferrer">here is an screenshot</a></p>
  
  <p>thanks</p>