select name from dbo.syscomments c, dbo.sysobjects o
where o.id = c.id and xtype = 'P' and text like '%表名%'
查询那些存储过程中使用到了某个表
最新推荐文章于 2023-07-11 14:29:01 发布
select name from dbo.syscomments c, dbo.sysobjects o
where o.id = c.id and xtype = 'P' and text like '%表名%'