Yogesh's Blog

Sharing me with blog…
Archive for the ‘Database’ Category

September 7th, 2010

Rename column in MSSQL 2005

No Comments, Database, by Yogesh.

Following query can be used to rename column in mssql 2005. EXEC sp_rename @objname = ‘table_name.old_column_name’, @newname = ‘new_column_name’, @objtype = ‘COLUMN’