title: How can I alter column name in Sql server
body: <p>I've a table Amount, having a column name amount_id which i want to change and update into account_id</p>
  
  <p>I am using sp_rename function but i dont know how exactly i can change it</p>
  
  <p>EXEC sp_rename 'Amount.Amount_id', 'Account_id', 'COLUMN';</p>
  
  <p>This is the error given</p>
  
  <p>Either the parameter @objname is ambiguous or the claimed @objtype (COLUMN) is wrong.</p>