sql server查询字段在哪个表

select tab.name as tableName,co.name as colName 
from sys.syscolumns co
join sys.tables tab on co.id=tab.object_id
where co.name like '字段名%'