Look up table with column name (SQL)

select a.name
from sysobjects a, syscolumns b
where a.id = b.id
and b.name = 'CFRMN_IND'