SQL Server 查找数据库对象的引用

方式一：使用 sp_depends

https://docs.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-depends-transact-sql

 

 

 

 

 

方式二：使用 sys.sql_expression_dependencies

USE DataBase
GO

SELECT TOP(100) o.name, o.type_desc, p.name as referenced_name, p.type_desc
FROM sys.sql_expression_dependencies d
INNER JOIN sys.objects o
    ON d.referencing_id = o.object_id
INNER JOIN sys.objects p
    ON d.referenced_id = p.object_id 
WHERE o.name = 'tableName'

 

方式三：使用 sys.dm_sql_referencing_entities

USE DataBase
GO

SELECT TOP(100) *
FROM sys.dm_sql_referencing_entities ('dbo.ObjectName', 'OBJECT');
GO