编写一个返回对象依赖关系的查询

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. Management Studio 连接到 SQL Server 2008
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

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