sp_rename

Sometimes you may need to alter table name or change table name in SQL Server. Here is how to rename table in SQL Server.