try below sql statment with admin permision

update sc

set sc.name=replace(sc.name,' ', '')

from sys.syscolumns sc,sys.sysobjects so

where so.id=sc.id and so.type ='u' and charindex(' ',sc.name)>0

--and so.name='table_name'