How to rename a table in SQL Server?

Question

The SQL query that I have used is :

ALTER TABLE oldtable RENAME TO newtable; 

But, it gives me an error.

Server: Msg 156, Level 15, State 1, Line 1
Incorrect syntax near the keyword 'TO'.

Answer 1

To rename a table in SQL Server, use the sp_rename command:

exec sp_rename 'schema.old_table_name', 'new_table_name' 

Answer 2

To rename a column:

sp_rename 'table_name.old_column_name', 'new_column_name' , 'COLUMN'; 

To rename a table:

sp_rename 'old_table_name','new_table_name';