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’
Yogesh's Blog
Sharing me with blog…
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’