编写查询以返回对象的依赖关系 [英] Write a query that returns the dependencies of an object

问题描述

我正在寻找Management Studio在查看依赖项菜单中显示的内容。

I'm looking for exactly what Management Studio shows with the "View Dependencies" menu.

1. 与SQL Server 2008连接的Management Studio


2. 右键单击对象，然后选择查看依赖关系。


3. 现在，您可以在依赖关系中来回导航。

如何以编程方式获取相同的信息？ （一个SQL查询？）

How do I get the same information programmatically? (an SQL query?)

推荐答案

Before you run the following query, replace <database_name> and <schema_name.function_name> with valid names

USE <database_name>;
GO
SELECT OBJECT_NAME(object_id) AS referencing_object_name
    ,COALESCE(COL_NAME(object_id, column_id), '(n/a)') AS referencing_column_name
    ,*
FROM sys.sql_dependencies
WHERE referenced_major_id = OBJECT_ID('<schema_name.function_name>')
ORDER BY OBJECT_NAME(object_id), COL_NAME(object_id, column_id);
GO

这篇关于编写查询以返回对象的依赖关系的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！