SQL语句得到存储过程关联哪些表名

 

 

SELECT DISTINCT '['+user_name(b.uid)+'].['+b.name+']' AS 对象名,b.type AS 类型

FROM sysdepends a,sysobjects b

WHERE b.id=a.depid

    AND a.id=OBJECT_ID('过程名');

  

EXEC SP_DEPENDS '过程名';

 

 

SELECT DISTINCT referenced_entity_name

FROM sys.dm_sql_referenced_entities ('dbo.HookCheck', 'object');