Rename column SQL Server 2008

sql sql-server sql-server-2008 alter-table

Use sp_rename

EXEC sp_RENAME 'TableName.OldColumnName' , 'NewColumnName', 'COLUMN'

For your case it would be:

EXEC sp_RENAME 'table_name.old_name', 'new_name', 'COLUMN'

Remember to use single quotes to enclose your values.

sql sql-server sql-server-2008 alter-table

Alternatively to SQL, you can do this in Microsoft SQL Server Management Studio. Here are a few quick ways using the GUI:

Slow double-click on the column. The column name will become an editable text box.

Right click on column and choose Rename from the context menu.

For example:

To Rename column name

This way is preferable for when you need to rename multiple columns in one go.

Right-click on the table that contains the column that needs renaming.
Click Design.
In the table design panel, click and edit the textbox of the column name you want to alter.

For example: MSSMS Table Design Example

_{NOTE: I know OP specifically asked for SQL solution, thought this might help others :)}

sql sql-server sql-server-2008 alter-table

Try:

EXEC sp_rename 'TableName.OldName', 'NewName', 'COLUMN'

CodeHunter