查看哪个SP调用了对应的表
1.查询某个表被哪些存储过程（以下简称 SP）使用到 :
select distinct object_name(id) from syscomments where id in
(select object_id from sys.objects where type ='P') and text like'%TableName%'
2.查找那些过程对该表做了更新操作：
select distinct object_name(id) from syscomments where id in
(select object_id from sys.objects where type ='P') and text like'%update tablename%'
3.查询当前数据库中所有SP：
select name as 存储过程 from sysobjects where type = 'P'
select distinct object_name(id) from syscomments where id in
(select object_id from sys.objects where type ='P') and text like'%TableName%'
2.查找那些过程对该表做了更新操作：
select distinct object_name(id) from syscomments where id in
(select object_id from sys.objects where type ='P') and text like'%update tablename%'
3.查询当前数据库中所有SP：
select name as 存储过程 from sysobjects where type = 'P'
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/16131092/viewspace-2152251/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
