select b.name as tablename from sys.columns a
left join sys.objects b on a.object_id=b.object_id left join sys.types t on a.system_type_id=t.system_type_id
where b.type = 'U' and charindex('UDT',t.name,0)<=0 and charindex('sys',t.name,0)<=0 and a.name ='列名'