title: change column name in sql server without using sp_rename
body: <p>I want to change my column name in sql server using a query, without using <code>sp_rename</code> command. Can you please tell me if anybody know it?</p>
  
  <p>I tried as:</p>
  
  <pre><code>alter table table_name alter column 'column1' to 'column2'
  </code></pre>
  
  <p>and it gave an error message as:</p>
  
  <pre><code>Msg 102, Level 15, State 1, Line 1
  Incorrect syntax near 'column1'.
  </code></pre>