or

select object_name(object_id) as table_name from sys.columns

where name='column_name' and objectproperty(object_id,'istable')=1