sqlserver查询列名以及表明

SELECT a.NAME,b.name
  FROM sys.columns a , sys.objects b
 WHERE a.object_id=b.object_id AND b.type='U'
   AND LOWER(a.name)='列名'