Rename column name in SQL Server 2008/2005

Recently I have been asked that we can change the name of column from GUI easily but how can we do it from T-SQL. Well, this is very small thing but when I have been asked, it strikes in my mind that quite a few people doesn’t know this actually so I decided to write this very small script. This task is easiest stuff in T-SQL with the help of sp_rename system stored procedure
Have a look.
–Emps is a tablename
–Name is current column name in emp table
–want to give new name “Name11” to old name “Name” of emps table
–“Column” at last, is a key word which tells SQL Server that we
–want to change column name
EXEC sp_rename ’emps.[name]’, ‘Name11’, ‘COLUMN’
Reference: Ritesh Shah
Note: Microsoft Books online is a default reference of all articles but examples and explanations prepared by Ritesh Shah, founder of