Declare @Id Int                               
Select @Id = Id From sysobjects Where Name = 'tblGuy_Info'
if not Exists(SELECT * FROM syscolumns WHERE id = @Id and Name = 'GoodsType')
  Alter Table dbo.tblGuy_Info Add GoodsType TINYINT DEFAULT(0) 