use [XYZ]    -- your database name
go

select name, type_desc from sys.all_objects where object_id in
(select object_id from sys.all_columns where upper(name)='<your column name>')
go