IF not EXISTS (
SELECT * FROM sys.columns WHERE object_id = OBJECT_ID(N'Employee') AND name = 'Name'
)
Begin
ALTER TABLE [Employee] ADD Name VARCHAR(200) NULL
end;
SELECT * FROM sys.columns WHERE object_id = OBJECT_ID(N'Employee') AND name = 'Name'
)
Begin
ALTER TABLE [Employee] ADD Name VARCHAR(200) NULL
end;