sqlexplore.wordpress.com
SQL SERVER 2008 – How to rename a column
There are many ways where in we can rename a column but what I prefer is using predefined stored Procedure sp_rename . Syntax : exec sp_rename ‘tablename.ColumnName’, ‘NewColumnName’, ‘column’ –o…