Inconsistent syntax in SQL Server’s sp_rename April 3rd, 2008

To rename columns in a SQL Server database, you can use sp_rename. The syntax of the command, in Transact-SQL-ese, is:

sp_rename
  [ @objname = ] ‘object_name’ ,
  [ @newname = ] ‘new_name’
  [ , [ @objtype = ] ‘object_type’ ]

So say you have a table called t_est, with a column in it called est_client. You want to rename these [...]

Read the rest of Inconsistent syntax in SQL Server’s sp_rename