We all sometimes need to rename a column/table from our database, however we do not want to drop all our records from the table where the column is renamed or the name of that table is changed.
For that there is such a nice SPROC in MS SQL: sp_rename.
This SPROC can be used to rename any user-created object in current DB.
However there is also a caution: