Use EnVisage
Go

IF not EXISTS(SELECT * FROM sys.columns 
            WHERE Name = N'Details' AND Object_ID = Object_ID(N'NonProjectTime'))
ALTER TABLE NonProjectTime
ADD Details nvarchar(500), Permanent bit