MSSQL Data lineage from view

datalineagefromview.sql

DECLARE @view_name sysname = '';

WITH cte AS (
    SELECT DISTINCT referenced_major_id
    FROM sys.sql_dependencies
    WHERE OBJECT_NAME(object_id) = @view_name
    AND is_updated = 0
)
SELECT o.name AS table_name, STRING_AGG(c.name, ', ') AS columns
FROM cte
JOIN sys.objects o ON o.object_id = cte.referenced_major_id AND o.type = 'U'
JOIN sys.columns c ON c.object_id = cte.referenced_major_id

GROUP BY o.name;