DECLARE @Id INT                               
SELECT @Id = Id FROM sysobjects Where Name = 'TmpDrugH'
IF NOT EXISTS(SELECT * FROM syscolumns WHERE id = @Id and Name = 'IsClub')
  ALTER TABLE dbo.TmpDrugH ADD IsClub BIT DEFAULT(0)