Renaming tables in SQL Server seems simple, but there are quite a few things to keep in mind.
Yes, the basic method is using sp_rename:
EXEC sp_rename 'Schema.OldName', 'Schema.NewName';
But this doesn’t update references in views, stored procedures,...