SQL - Rename global temporary table

Dear Experts,

Could you please advise about the syntax how to rename a table by an SQL statement?

Concretely in my test that table is a global temporary table, created by:

CREATE TABLE
	##TempTable (VendorNumber NVARCHAR(20), VendorName NVARCHAR(70));

Select allOpen in new window

where:

SELECT * FROM dbo.##TempTable

Select allOpen in new window

confirms that it has been created.

But trying the rename for that by syntax:

EXEC sp_rename [tempdb.dbo.##TempTable], [tempdb.dbo.##TempTableRenamed];

Select allOpen in new window

getting an error message that:

An invalid parameter or option was specified for procedure 'sys.sp_rename'.


Could you please advise what is wrong with the syntax concretely in this example?

Thanks in advance