Add Columns to a Table (Database Engine) - MSDN
This topic describes how to add new columns to a table in SQL Server 2016 by using SQL Server Management Studio or Transact-SQL. ... Using the ALTER TABLE statement to add columns to a table automatically adds those columns to the ......