--查看指定表名被哪些视图、存储过程调用
SELECT name
FROM sysobjects AS s
INNER JOIN syscomments AS o
ON s.id = o.id
WHERE text LIKE N'%DWS_T_LRFJ_ACT_M_TOTALSALSVOLSUM%';
sql server查看指定对象调用情况
最新推荐文章于 2024-03-13 14:21:11 发布
--查看指定表名被哪些视图、存储过程调用
SELECT name
FROM sysobjects AS s
INNER JOIN syscomments AS o
ON s.id = o.id
WHERE text LIKE N'%DWS_T_LRFJ_ACT_M_TOTALSALSVOLSUM%';