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

2022-01-15 00:00:00 dependencies sql-server-2008 sql-server

我正在寻找 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

相关文章