Declare @Id Int                               
Select @Id = Id From sysobjects Where Name = 'KalaId'
if not Exists(SELECT * FROM syscolumns WHERE id = @Id and Name = 'Brand_Code')
 alter table KalaId  Add Brand_Code Varchar(6) Null