075. Find Object Dependency in SQL Server

Performance Improvement in SQL, SQL Downloads, SQL SERVER, Sql Server Scripts
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
-- Script - 1 
SELECT DISTINCT
    SO.Name
    ,SO.XType AS ObjectType
    ,SC.TEXT AS ObjectDefinition
FROM syscomments AS SC
INNER JOIN sysobjects AS SO ON SC.id=SO.id
WHERE SC.TEXT LIKE '%tablename%'
GO
 
-- Script - 2
SELECT OBJECT_NAME(OBJECT_ID)
  FROM sys.sql_modules
 WHERE DEFINITION LIKE '%tablename%'
GO
 
-- Script - 3
SELECT
    referencing_schema_name, referencing_entity_name, referencing_id,
    referencing_class_desc, is_caller_dependent
FROM
    sys.dm_sql_referencing_entities ('SchemaName.TableName', 'Object');
GO