title: Renaming a column: Incorrect syntax near 'SP_RENAME'.?
body: <pre><code>ALTER TABLE [TEMP]
  SP_RENAME '[TEMP].[Day]', 'GT', 'COLUMN'
  </code></pre>
  
  <p>I am trying to rename <code>Day</code> to <code>GT</code> and am getting the error </p>
  
  <blockquote>
    <p>Incorrect syntax near 'SP_RENAME'</p>
  </blockquote>
  
  <p>SQL Server Management Studio says the error is on <code>SP_RENAME</code></p>
  
  <p>NOTE: I'm open to other options besides sp_rename</p>