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.