How To Find Columns In All Tables Sybase / ENIQ Database

Just Run Query

-- @denjaka
select 
  b.name as tablename
  , a.name as columnname
from dbo.syscolumns a 
join dbo.sysobjects b 
  on (a.id = b.id) 
where 
  b.type='U' 
  and a.name like '%BSCGPRS%' --> column name