By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE t (id int);
CREATE VIEW v
AS
SELECT t.id
FROM dbo.t;
select
schema_name = s.name,
view_name = v.name,
column_name = r.name,
r.source_database,
r.source_schema,
r.source_table,
r.source_column
from sys.views v
join sys.schemas s on s.schema_id = v.schema_id
cross apply sys.dm_exec_describe_first_result_set(
N'SELECT v.* FROM ' + quotename(s.name) + '.' + quotename(v.name) + ' v', NULL, 1) r;
| schema_name | view_name | column_name | source_database | source_schema | source_table | source_column |
|---|---|---|---|---|---|---|
| dbo | v | id | fiddle_4d596d491cf74f8d991daf922e9c9e71 | dbo | t | id |