USE EnVisage GO IF EXISTS(SELECT * FROM sys.columns WHERE Name = N'Weekends' AND Object_ID = Object_ID(N'Training')) BEGIN ALTER TABLE Training DROP COLUMN Weekends, PercentAllocated END