要删除的表名为变量，该怎么写？

--set   nocount   on  
  declare   @table_name   char(30),@sql   varchar(100),@drug_code   char(20)  
  declare   find_table_name_set   cursor   for  
  select   name    
  from   sysobjects  
  where   (id   in   (select   id   from   syscolumns   where   name='drug_code'))  
    and   (id<>1716917188)  
    and   (xtype<>'v')  
  OPEN   find_table_name_set  
   
  FETCH   NEXT   FROM   find_table_name_set    
  INTO   @table_name  
  WHILE   @@FETCH_STATUS   =   0  
  BEGIN    
        set   @drug_code='1010'  
        set   @sql='DELETE   FROM   '+@table_name+'   WHERE   drug_code=   '+@drug_code  
        exec(@sql)     -----这样修改  
  END  
  close   find_table_name_set  
  deallocate   find_table_name_set