SqlServer查询存储过程和视图是否用到表字段

 

查询存储过程视图是否用到表和字段

?

1 2 3 4

select name from sysobjects as s inner join syscomments as o on s.id=o.id where text like N'%表名%字段名%'

--查询表字段
SELECT OBJECT_NAME(object_id) '表名',name AS '列名称' FROM sys.columns