DECLARE @Id Int                               
SELECT @Id = Id From sysobjects Where Name = 'DrugH'
if not Exists(SELECT * FROM syscolumns WHERE id = @Id and Name = 'FamilyDoctorCode')
  ALTER TABLE dbo.DrugH ADD FamilyDoctorCode INT NULL DEFAULT(0)
