IF EXISTS (  
 SELECT 1 FROM SYSOBJECTS T1  
  INNER JOIN SYSCOLUMNS T2 ON T1.ID=T2.ID  
 WHERE lower(T1.NAME)='expensivegoodsapplication' AND T2.NAME='patient'  
 )  
 alter table expensivegoodsapplication drop column patient;

IF EXISTS (  
 SELECT 1 FROM SYSOBJECTS T1  
  INNER JOIN SYSCOLUMNS T2 ON T1.ID=T2.ID  
 WHERE lower(T1.NAME)='expensivegoodsapplication' AND T2.NAME='hospitalNumber'  
 )  
alter table expensivegoodsapplication drop column hospitalNumber;