How to Alter table add column in SQL Server
After create the table, you may need for change in the table. You can change directly using design view. But for the deployment or you are using live server, it is recommended that write the query for change the structure in table. Here is syntax of alter table and add more columns in existing table
Alter Table [Table Name] Add [Column Name] [datatype]
Add column in Customers table
Here you will write the table name instead of table name. For multiples column you will write same script with different columns. Example is given below.
Alter Table Customers Add Cust_City nvarchar(50)
Alter Table Customers Add Cust_State nvarchar(50)