How to Add New Column to a Sql Server table

You can use of the below ways to add a new column to a Sql server table. Easiest way is to use the Management Studio.

Open the Sql Server Management studio -> Expand the database node -> Expand the tables -> Expand the specific table -> Right click on columns -> New Column..



Other way is to use a Sql query. Run the below query to add a new column.

ALTER TABLE tblABS ADD
NewColumn VARCHAR(200) NULL