How to rename a table in SQL Server

To rename a database table use this code:

USE Database_name;
GO
EXEC sp_rename 'Old_Table_Name', 'New_Table_Name';
GO