查询某个字段在数据库中的哪些地方用到

1.哪个表（视图、存储过程）中有这个字段

Select Object_Name(ID) 表名,Name 字段名 From Syscolumns Where Name like '%字段名%'

 

2.显示出这个字段的类型（表、视图）

select
a.Name as 表名,
b.Name as 列名,
c.Name as 类型,
b.max_length as 字节数,
b.Precision as 整数位,
b.Scale as 小数位
from Sys.tables a
inner join Sys.columns b on a.object_id=b.object_id
inner join sys.Types c on c.User_Type_ID=b.User_Type_ID
Where b.Name like '%字段名%'

3.这个字段在哪些地方出现过
SELECT [number], [text], A.name
FROM syscomments B, sysobjects A
WHERE A.[id]=B.[id]
and TEXT like '%receipt%'
ORDER BY [number]