SQL Server 2022

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE t_test(a int, b int, c int, d int, e int)
CREATE VIEW v_test AS
 WITH w_test AS (
  SELECT *, c + d AS cd_computed 
  FROM t_test
 )
 SELECT a AS a_renamed, c, cd_computed 
 FROM w_test
select
  r.referenced_server_name,
  r.referenced_database_name,
  r.referenced_schema_name,
  r.referenced_entity_name,
  r.referenced_minor_name
from sys.dm_sql_referenced_entities ('dbo.v_test', 'OBJECT') r
where r.referenced_minor_name is not null;


referenced_server_name
referenced_database_name
referenced_schema_name
referenced_entity_name
referenced_minor_name


null
null
null
t_test
a

null
null
null
t_test
b

null
null
null
t_test
c

null
null
null
t_test
d

null
null
null
t_test
e

referenced_server_name	referenced_database_name	referenced_schema_name	referenced_entity_name	referenced_minor_name
null	null	null	t_test	a
null	null	null	t_test	b
null	null	null	t_test	c
null	null	null	t_test	d
null	null	null	t_test	e