The builtin “sp_rename” procedure can be used to change or rename the name of an existing table. In this case, the existing name and new name must be provided to the sp_rename procedure.
SQL Syntax to Rename a Table:
EXEC sp_rename 'OldTableName', 'NewTableName'
For more detail on “sp_rename” CLICK HERE.