1. In Object Explorer, right-click the table to which you want to add columns and choose Design.
2. Select the first blank cell in the Column Name column.
3. Type the column name in the cell. …
4. Press the TAB key to go to the Data Type cell and select a data type from the dropdown.

1. In Object Explorer, right-click the table to which you want to add columns and choose Design.
2. Select the first blank cell in the Column Name column.
3. Type the column name in the cell.
4. Press the TAB key to go to the Data Type cell and select a data type from the dropdown.

SQL Server Management Studio should be used.
Right-click the table to which you wish to add columns in Object Explorer and select Design.
Choose the first empty cell in the Column Name column.
In the cell, type the name of the column….
To navigate to the Data Type cell, use the TAB key and select a data type from the list.