Summary: in this tutorial, you will learn how to use SQL Server ALTER TABLE ADD statement to add one or more columns to a table.. The following ALTER TABLE ADD statement appends a new column to a table:

This tutorial shows you how to use the SQL ADD COLUMN clause of the ALTER TABLE statement to add one or more columns to an existing table.

SQL Add Column example. To add a new column to the existing table, please use the following Alter table Add Column syntax-- SQL Server Add Column ALTER TABLE [Table_Name] ADD [New_Column] Data_Type (Length) NULL | NOT NULL. In this SQL example, we are goi