alter table in ssms code example

Example: add multiple columns to table sql

ALTER TABLE table_name
  ADD column_1 column_definition,
      column_2 column_definition,
      ...
      column_n column_definition;