DECLARE @Id Int                               
                             
Select @Id = Id From sysobjects Where Name = 'Tbl_Clubh'
IF not Exists(SELECT * FROM syscolumns WHERE id = @Id and Name = 'Email')
  Alter Table Tbl_Clubh Add Email VARCHAR(50)

Select @Id = Id From sysobjects Where Name = 'Tbl_Clubh'
IF not Exists(SELECT * FROM syscolumns WHERE id = @Id and Name = 'PostalCode')
  Alter Table Tbl_Clubh Add PostalCode VARCHAR(20)


Select @Id = Id From sysobjects Where Name = 'Tbl_Clubh'
IF not Exists(SELECT * FROM syscolumns WHERE id = @Id and Name = 'Position')
  Alter Table Tbl_Clubh Add Position VARCHAR(50)

Select @Id = Id From sysobjects Where Name = 'Kalaid'
IF not Exists(SELECT * FROM syscolumns WHERE id = @Id and Name = 'SalesCeiling')
  Alter Table Kalaid Add SalesCeiling INT NOT NULL DEFAULT(0)


