T-SQL Tutorial

SQL Alter Table Add Column


Add Column Syntax:

ALTER TABLE table_name
ADD column_name data_type

Employee table:

Column nameData_type
idint
namevarchar(250)

Add Column Example:

ALTER TABLE employee
ADD (dep_id int, address varchar(100));

Add Column Result:

Column nameData_type
idint
namevarchar(250)
dep_idint
addressvarchar(100)