title: Problem with Renaming a Column in SQL Server
body: <p>So I was trying to rename a column in my table from <code>Conversion_Fee_PerShare</code> to just <code>Conversion Fee</code>.</p>
  
  <p>I looked up online and found the syntax be:</p>
  
  <pre><code>sp_RENAME 'TableName.[OldColumnName]', '[NewColumnName]', 'COLUMN'
  </code></pre>
  
  <p>I wrote my query as:</p>
  
  <pre><code>sp_RENAME 'dbo.AllocationDetails.[Conversion_Fee_Per_Share]' , '[Conversion_Fee]', 'COLUMN'
  </code></pre>
  
  <p>The column name has now become <code>[Conversion_Fee]</code> instead of <code>Conversion_Fee</code></p>
  
  <p>Now if am trying to rename again like this:</p>
  
  <pre><code>sp_RENAME 'dbo.AllocationDetails.[Conversion_Fee]' , 'Conversion_Fee', 'COLUMN'
  </code></pre>
  
  <p>It gives me an error saying: </p>
  
  <blockquote>
    <p>Msg 15248, Level 11, State 1,
    Procedure sp_rename, Line 213 Either
    the parameter @objname is ambiguous or
    the claimed @objtype (COLUMN) is
    wrong.</p>
  </blockquote>
  
  <p>I tried to Alter Table Drop Column AllocationDetails.[Conversion_Fee] it didn't work that way either.</p>
  
  <p>Whats the right syntax?</p>