Developers can use SQL Server “Denali”, MS SQL Server 2008 R2 and MS SQL Server 2005 Table Designer to add new columns to a table. When developers open a table in Table Designer, they see all of its currently defined columns as well as a blank row at the bottom of the table definition grid. They can add columns either in the blank row or they can insert them between existing rows, 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 to which they want to add columns and choose Design (Modify in SP1 or earlier).

Table Designer opens with the cursor placed in the first blank cell in the Column Name column. They can also right-click a row in the table and select Insert Column from the shortcut menu. A blank column row is inserted.

2. In the Column Name column, type the column name in the cell. The column name is a required value.

3. Press the TAB key to go to the Data Type cell and select a data type from the dropdown. This too is a required value, and will be assigned the default value if they don’t choose one.

4. Continue to define any other column properties in the Column Properties tab.