EnVisageOnline/Main/Database/Scripts/20160215/02_Holidays_Alter_EndDate.sql

USE [EnVisage]
GO

IF EXISTS(SELECT * FROM sys.columns 
            WHERE Name = N'EndDate' AND Object_ID = Object_ID(N'Holiday'))
BEGIN
ALTER TABLE Holiday ALTER COLUMN EndDate datetime NULL
END
GO