SQLServer - 如何在我的表上查找依赖表？

-- 查找依赖于 my_table 的表
SELECT
    OBJECT_SCHEMA_NAME(referenced_id) AS referencing_schema,
    OBJECT_NAME(referenced_id) AS referencing_table,
    COL_NAME(referenced_id, referenced_minor_id) AS referencing_column
FROM
    sys.dm_sql_referenced_entities('my_table', 'OBJECT')
WHERE
    OBJECT_NAME(referenced_id) <> 'my_table';

-- 查找 my_table 所依赖的表
SELECT
    OBJECT_SCHEMA_NAME(referencing_id) AS referencing_schema,
    OBJECT_NAME(referencing_id) AS referencing_table,
    COL_NAME(referencing_id, referencing_minor_id) AS referencing_column
FROM
    sys.dm_sql_referencing_entities('my_table', 'OBJECT')
WHERE
    OBJECT_NAME(referencing_id) <> 'my_table';