Change Table Name Using sp_Rename Procedure

CREATE TABLE Temp_Customer

(
id INT IDENTITY(1, 1),
varName VARCHAR(15)
)

INSERT INTO Temp_Customer (varName) VALUES ('Nirav')

INSERT INTO Temp_Customer (varName) VALUES ('Rahul')

SELECT * FROM Temp_Customer

EXEC sp_Rename oldTableName,NewTableName


EXEC sp_Rename 'Temp_Customer','Temp_CustomerData'

SELECT * FROM Temp_CustomerData