Alter table to add new column

Ranjeet_8
Posted by Ranjeet_8 under Sql Server category on | Points: 40 | Views : 1623
Create Table:
CREATE TABLE [dbo].[Employee](
[First_Name] [varchar](50) NULL,
[City] [varchar](50) NULL
)

Alter table to add new column :
ALTER TABLE Employee
ADD eBonus SmallInt Null

Comments or Responses

Posted by: Srilu.Nayini577 on: 8/11/2012 Level:Starter | Status: [Member] | Points: 10
alter table Employee
add sal double

Login to post response