Rename SQL Column Error : Either the parameter @objname is ambiguous or the claimed @objtype (COLUMN) is wrong
<p>I wanted to rename my column.</p>

<p>I referred <a href="http://blog.sqlauthority.com/2008/08/26/sql-server-how-to-rename-a-column-name-or-table-name/" rel="nofollow noreferrer">this</a> document.</p>

<p>I wrote a query as:</p>

<pre><code>sp_RENAME '[dbo].[File].[JSONFile]', '[ARAInputJson]', 'COLUMN'
</code></pre>

<p>But now column is created as <code>[ARAInputJson]</code></p>

<p>But I don't want to put square brackets to it.</p>

<p>So again I wrote it as :</p>

<pre><code>sp_RENAME '[dbo].[File].[[ARAInputJson]]' , 'ARAInputJson', 'COLUMN'
</code></pre>

<p>But I get this error :</p>

<blockquote>
  <p>Msg 15248, Level 11, State 1, Procedure sp_rename, Line 215<br>
  Either the parameter @objname is ambiguous or the claimed @objtype (COLUMN) is wrong.</p>
</blockquote>

<p>Please help me to rename column from <code>[ARAInputJson]</code> to <code>ARAInputJson</code>.</p>