Programmer
MS SQL Server
Menu
Programmer
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)
Newer Posts
Older Posts
Home
Subscribe to:
Posts (Atom)