USE EnVisage
GO

IF EXISTS(SELECT * FROM sys.columns 
            WHERE Name = N'HoursOff' AND Object_ID = Object_ID(N'Vacation'))
BEGIN
    ALTER TABLE Vacation
	DROP COLUMN HoursOff, Weekends
END