How to rename a table in SQL Server?
To rename a table in SQL Server, use the sp_rename command:
alter-table
Rename column SQL Server 2008
Use sp_rename See: SQL SERVER – How to Rename a Column Name or Table Name Documentation: sp_rename (Transact-SQL) For your case it would be: Remember to use single quotes to enclose your values.