找出存储过程相关表

select name from sysobjects where id in(SELECT distinct bb.depid as kk
FROM sysobjects
JOIN sysdepends bb ON bb.id = sysobjects.id
where sysobjects.name=@#存储过程名@#)
--By HuntFox

原文转自：http://www.ltesting.net