SQL Server 2022

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

CREATE TABLE Employees (
  ID int PRIMARY KEY,
  FullName varchar(100),
  JoiningDate date,
  DeptID int,
  RegionID int);

CREATE TABLE Departments (
  ID int PRIMARY KEY,
  DepartmentName varchar(100));

CREATE TABLE Regions (
  ID int PRIMARY KEY,
  RegionName varchar(100));
CREATE VIEW dbo.YourView
AS
SELECT Emp.ID, Emp.FullName, Emp.JoiningDate, Dept.DepartmentName, Reg.RegionName
FROM Employees AS Emp
    INNER JOIN Departments AS Dept
        ON Dept.ID = Emp.DeptID
    INNER JOIN Regions AS Reg
        ON Reg.ID = Emp.RegionID
select
  ed.name,
  CONCAT_WS(N'.',
    ed.source_server,
    ed.source_database,
    ed.source_schema,
    ed.source_table,
    ed.source_column) AS source_column
from sys.dm_exec_describe_first_result_set(
  N'SELECT * FROM dbo.YourView', NULL, 1) ed
where ed.is_hidden = 0;


name
source_column


ID
fiddle_eaa98e1a2618420c85289ecc10cfa792.dbo.Employees.ID

FullName
fiddle_eaa98e1a2618420c85289ecc10cfa792.dbo.Employees.FullName

JoiningDate
fiddle_eaa98e1a2618420c85289ecc10cfa792.dbo.Employees.JoiningDate

DepartmentName
fiddle_eaa98e1a2618420c85289ecc10cfa792.dbo.Departments.DepartmentName

RegionName
fiddle_eaa98e1a2618420c85289ecc10cfa792.dbo.Regions.RegionName

name	source_column
ID	fiddle_eaa98e1a2618420c85289ecc10cfa792.dbo.Employees.ID
FullName	fiddle_eaa98e1a2618420c85289ecc10cfa792.dbo.Employees.FullName
JoiningDate	fiddle_eaa98e1a2618420c85289ecc10cfa792.dbo.Employees.JoiningDate
DepartmentName	fiddle_eaa98e1a2618420c85289ecc10cfa792.dbo.Departments.DepartmentName
RegionName	fiddle_eaa98e1a2618420c85289ecc10cfa792.dbo.Regions.RegionName