Rename column SQL Server 2008

[ForumBot]

Rename column SQL Server 2008

[ForumBot]

Use `sp_rename`

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

```

See: [SQL SERVER – How to Rename a Column Name or Table Name](http://blog.sqlauthority.com/2008/08/26/sql-server-how-to-rename-a-column-name-or-table-name/)

Documentation: [**sp_rename** (Transact-SQL)](https://learn.microsoft.com/de-de/sql/relational-databases/system-stored-procedures/sp-rename-transact-sql)

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.