SQL Server数据库中查询含有某个字段的表及该表记录条数

SELECT object_name(sc.id) as TableName, sc.Name as ColumnName, si.rows as RowCounts FROM SysColumns sc LEFT JOIN SysObjects so ON sc.id = so.id 

LEFT JOIN SysIndexes si ON sc.id = si.id WHERE so.type='u' AND sc.name LIKE 'teamid%' AND si.indid IN (0, 1) ORDER BY si.rows DESC

感觉这个偶尔会用得到，放在这里供人拷贝