Menu

Saturday, 17 May 2014

Add New Column IN Table



It is used to add new column with datatype in the existing table.

Syntax


ALTER TABLE Employee ADD Column_Name DataType(Data Size)


Example-

Alter Table Employee Add EmployeeCity nvarchar(50)

OutPut


Employee (Before)



Employee (After)