找出存储过程相关表
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
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