MSSQL 테이블 종속성 확인 쿼리 | 데이터카페

MSSQL 테이블에 연결된 프로시저 확인 방법
code

SELECT referenced_entity_name AS referenced_table
        , OBJECT_NAME(referencing_id) AS referencing_table
 FROM sys.sql_expression_dependencies
 where referenced_entity_name = 'TABLE_NAME'
 order by referenced_entity_name