USE [EnVisage] GO if not exists(select * from sys.columns where Name = N'CostSavingsDescription' and Object_ID = Object_ID(N'Scenario')) begin ALTER TABLE Scenario ADD CostSavingsDescription nvarchar(500) end GO