select name,type_desc from sys.all_sql_modules s
inner join sys.all_objects o on s.object_id=o.object_id
where definition like '%表名%' order by type_desc,name
SQL Server查询某个表应用在哪些存储过程
最新推荐文章于 2023-06-09 08:41:00 发布
select name,type_desc from sys.all_sql_modules s
inner join sys.all_objects o on s.object_id=o.object_id
where definition like '%表名%' order by type_desc,name