USE [EnVisage]
GO

IF EXISTS (SELECT * FROM sys.tables where name='PeopleResource')
begin

ALTER TABLE PeopleResource
 ADD EmployeeID nvarchar(100);
end