SQLSERVER查看包含某个字段的所有表

查看包含某个字段的所有表：

select [name] from sysobjects where [id] in (select[id] from syscolumns where [name] = 'nettime') ORDER BY Name

select [name] from sysobjects where [id] in (select[id] from syscolumns where [name] = 'loadtime') ORDER BY Name

查看表名包含某个字符串的所有表：

SELECT Name FROM SysObjects Where XType='U' and name like '%loadtime%' ORDER BY Name
查看包括某个字符串的所有存储过程：

select distinct(name) from sysobjects o, syscomments s where o.id = s.id and text like '%loadtime%' and o.xtype = 'P' order by name