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

Question

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

Management Studio 连接到 SQL Server 2008

右键单击一个对象并选择“查看依赖项”

现在您可以来回浏览依赖项。

如何以编程方式获取相同的信息？ (SQL 查询？)

Answer 1

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