/*
查询某张表被哪些存储过程或者视图用到的sql语句
*/
select distinct object_name(id) from syscomments
where id in (select id from sysobjects where type in('V','P'))
and text like '%表名%'
转载于:https://www.cnblogs.com/wangdodo/p/6401951.html
/*
查询某张表被哪些存储过程或者视图用到的sql语句
*/
select distinct object_name(id) from syscomments
where id in (select id from sysobjects where type in('V','P'))
and text like '%表名%'
转载于:https://www.cnblogs.com/wangdodo/p/6401951.html