T-SQL语句查询表或存储过程被其它存储过程调用情况

羽叶

将TableNameOrProcedureName改成实际的表名或存储过程名称

[SQL] 纯文本查看 复制代码

SELECT DISTINCT NAME FROM SYSCOMMENTS COMM,SYSOBJECTS OBJ   
WHERE COMM.ID=OBJ.ID AND OBJ.XTYPE='P' AND TEXT LIKE '%TableNameOrProcedureName%'