Best Methods to Rename a Table in SQL Server

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,...