پیدا کردن وابستگی‌های یک شی در SQL Server

SELECT * FROM sys.dm_sql_referencing_entities('[mySchema].myEntity', 'Object')

SELECT * FROM sys.dm_sql_referenced_entities('[mySchema].myEntity', 'Object')

SELECT DISTINCT 'mySchema.MyEntity',
                referenced_entity_name + '.' + referenced_schema_name
FROM sys.dm_sql_referenced_entities('[mySchema].MyEntity', 'Object') r
         LEFT JOIN sys.objects o ON o.object_id = r.referenced_id
WHERE o.object_id IS NULL;

CREATE TABLE #Temp
(
    TargetName    VARCHAR(500),
    ReferenceName VARCHAR(500)
);

SELECT 'Insert Into #Temp
SELECT Distinct ''' + SCHEMA_NAME(o.schema_id) + '.' + o.name +
       ''',  referenced_entity_name + ''.'' + referenced_schema_name from sys.dm_sql_referenced_entities(''[' +
       SCHEMA_NAME(o.schema_id) + '].' + o.name + ''',''Object'') r
LEFT JOIN sys.objects o on o.object_id = r.referenced_id
where o.object_id is null'
FROM sys.objects o;