Sponser Link

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)