Developers can rename a table in SQL Server “Denali”, MS SQL Server 2008 R2 and MS SQL Server 2005 Table Designer, by following the next steps:

C# 8.0 and .NET Core 3.0 – Modern Cross-Platform Development: Build applications with C#, .NET Core, Entity Framework Core, ASP.NET Core, and ML.NET using Visual Studio Code, 4th Edition
ASP.NET Core 3 and Angular 9: Full stack web development with .NET Core 3.1 and Angular 9, 3rd Edition
C# in Depth, 4th Edition

1. In Object Explorer, right-click the table they want to rename and choose Design (Modify in SP1 or earlier).

The table opens in the Table Definition window of Table Designer.

2. From the View menu, choose Properties.

3. In the field for the Name value in the Properties window, type a new name for the table.

4. To cancel this action, press the ESC key before leaving this field.

5. From the File menu choose Save table name.

When developers rename a table and save it, its name is automatically updated in the database. Developers have to check in advance existing queries, views, user-defined functions, stored procedures, or programs refer to the renamed table, because its name modification will make these objects invalid.