Wednesday, September 16, 2009

How do I rename a column using SQL Server?

It's very easy to rename a column using SQL Server:

sp_rename 'table.old_column_name', 'new_column_name'

very simple, isn't it?