编写一个返回对象依赖关系的查询
我正在寻找 Management Studio 通过查看依赖项"菜单显示的确切内容.
I'm looking for exactly what Management Studio shows with the "View Dependencies" menu.
- Management Studio 连接到 SQL Server 2008
- 右键单击对象并选择查看依赖项"
- 现在您可以来回浏览依赖项.
如何以编程方式获取相同的信息?(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
相关文章