특정 컬럼의 의존성(Dependencies)를 찾는 쿼리 혹은 툴

SELECT DISTINCT 'TABLES'  AS OBJECT, t.TABLE_TYPE AS OBJECT_TYPE, t.TABLE_NAME AS [OBJECT_NAME]  
  FROM INFORMATION_SCHEMA.Columns c INNER JOIN INFORMATION_SCHEMA.Tables t
    ON t.TABLE_CATALOG = c.TABLE_CATALOG AND t.TABLE_SCHEMA = c.TABLE_SCHEMA AND t.TABLE_NAME = c.TABLE_NAME 
 WHERE COLUMN_NAME IN ('컬럼명')
 UNION
SELECT DISTINCT 'ROUTINES' AS OBJECT, ROUTINE_TYPE  AS OBJECT_TYPE, ROUTINE_NAME AS [OBJECT_NAME]  
  FROM INFORMATION_SCHEMA.Routines 
 WHERE ROUTINE_DEFINITION LIKE '%컬럼명%'

원문

더 찾다 보니 Red-Gate SQL Search라는 툴도 있구나. 원문