Question

Add multiple columns to table in MS Sql

Answer

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

Links/related reading

• https://www.techonthenet.com/sql_server/tables/alter_table.php
• https://docs.microsoft.com/en-us/previous-versions/sql/sql-server-2005/ms190273(v=sql.90)?redirectedfrom=MSDN#g-adding-several-columns-with-constraints

---

📇Additional Metadata

• Type::question-answer
• Tags:: T-SQL, MS Sql
• Status::🌲