Menu

Showing posts with label add new column in employee table in ms sql server 2008. Show all posts
Showing posts with label add new column in employee table in ms sql server 2008. Show all posts

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)