Declare @SmsFlag Int                               
Select @SmsFlag = Id From sysobjects Where Name = 'Guy'
if not Exists(SELECT * FROM syscolumns WHERE id = @SmsFlag  and Name = 'SmsFlag')
ALTER TABLE Guy ADD  SmsFlag  Char (1) Default(0)