How to rename a column in a SQL table?

Read Best Answer

Editorial / Best Answer

sravee123  

 Profile Answers by sravee123 Questions by sravee123

• Member Since May-2008 | Jun 10th, 2008

---

ALTER TABLE table_name RENAME COLUMN old_name to new_name;

Ex: ALTER TABLE employee RENAME COLUMN eno to empno;

srikanth.cherukupalli

 Profile Answers by srikanth.cherukupalli Questions by srikanth.cherukupalli

• Jan 12th, 2012

Code
ALTER TABLE emp RENAME COLUMN emp_id TO id;

karthickrfwin

 Profile Answers by karthickrfwin Questions by karthickrfwin

• Sep 22nd, 2011

Use this Script for nename particular ColumnName in SqlTable

sp_rename 'TableName.[ColumnNameOld]','[ColumnNameNew]','Column'

Improve Answer