Developers can use SQL Server “Denali”, MS SQL Server 2008 R2 and MS SQL Server 2005 Table Designer to rename a column directly in their tables, 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 with the columns they want to rename and choose Design (Modify in SP1 or earlier). The table opens in Table Designer.

2. Under Column Name, select the name they want to change and type a new one.

The column is renamed in their table as soon as they exit the cell. The column is renamed in their database they save the table.