SQL查询不为空的所有表名:
select distinct object_name(id),rowcnt from sys.sysindexes where rowcnt>0 ;
查询到包含有某个字段的所有表名:
SELECT b.name as TableName,a.name as columnname
From syscolumns a INNER JOIN sysobjects b
ON a.id=b.id
AND b.type='U'AND a.name='你的字段名字'