Add New Column in MSSQL

Add a new column in MSSQL 

alter table <<table_name>>
add <<columnname>> <<data type>>

Example :-

alter table employee
add first_name varchar(25)

Advertisements