USE [EnVisage]
GO
IF NOT EXISTS(SELECT * FROM sys.columns
WHERE Name = N'Email' AND Object_ID = Object_ID(N'PeopleResource'))
BEGIN
ALTER table [dbo].[PeopleResource] Add [Email] [nvarchar](320) NULL
end
go