如何在视图中获取列级依赖

此解决方案只能部分回答您的问题。它不适用于作为表达式的列。

您可以使用sys.dm_exec_describe_first_result_set获取列信息：

@include_browse_information

如果设置为1，则将对每个查询进行分析，就像在查询中具有FOR BROWSE选项一样。返回其他键列和源表信息。

CREATE TABLE txu(id INT, first_name VARCHAr(10), last_name VARCHAr(10));CREATE TABLE txd(id INT, id_fk INT, address VARCHAr(100));CREATE VIEW v_txuASSELECt t.id AS PK_id,       t.first_name  AS name,       d.address,       t.first_name + t.last_name AS name_fullFROM txu tJOIN txd d  ON t.id = d.id_fk

主要查询：

SELECt name, source_database, source_schema,      source_table, source_column FROM sys.dm_exec_describe_first_result_set(N'SELECt * FROM v_txu', null, 1) ;

输出：

+-----------+--------------------+---------------+--------------+---------------+|   name    |   source_database  | source_schema | source_table | source_column |+-----------+--------------------+---------------+--------------+---------------+| PK_id     | fiddle_0f9d47226c4 | dbo| txu          | id || name      | fiddle_0f9d47226c4 | dbo| txu          | first_name    || address   | fiddle_0f9d47226c4 | dbo| txd          | address       || name_full | null    | null          | null         | null          |+-----------+--------------------+---------------+--------------+---------------+

DBFiddleDemo