EXEC sp_rename 'schemaName.oldTableName', 'newTableName';

References:

https://docs.microsoft.com/en-us/sql/relational-databases/tables/rename-tables-database-engine