Rohit Bhagwani

Rohit Bhagwani

  • 1.6k
  • 15
  • 1.2k

Column Lineage in SQL

Jan 4 2024 12:15 PM

Hello,

In my database, there is a table named "table1" with columns col1, col2, and col3. This table is referenced by multiple views:

So as per the above example the column "Col1" from table1 is being used directly or indirectly in below components

dbo.view1

dbo.view2

dbo.view3

xyz.view4

Now, I want to determine the column lineage specifically for "Col1" in "table1" within the database. Is it possible to retrieve this information using metadata tables or any other means?


Answers (3)