【SQL Server点滴积累】SQL Server 2008 查看依赖关系

广告位招租！

知识无价，人有情，无偿分享知识，希望本条信息对你有用！

今天和大家分享两段有用的代码

在SQL Server 2008中如何查看一个数据库对象（Database Object）的依赖关系

--Change the "dbo.v_searchall" into your own object

SELECT OBJECT_NAME(referencing_id) AS referencing_entity_name 
    ,referenced_server_name AS server_name
    ,referenced_database_name AS database_name
    ,referenced_schema_name AS schema_name
    , referenced_entity_name
FROM sys.sql_expression_dependencies 
WHERE referencing_id = OBJECT_ID(N'dbo.v_searchall');

分层查看依赖关系

--Change the "v_searchall" into your own object

DECLARE @referencing_entity AS sysname;

SET @referencing_entity = N'v_searchall';