Determine Table Columns Associated with View Columns

[grnzbra]

If I want to know the columns associated with a table, I can do a join on the sys.tables and sys.columns tables
If I wnnt to know the columns associated witn a view, I can do a join on the sys.views and sys.columns tables.
In both cases, I would join on object_id.
If a column appears in a view, it has two records in the sys.columns table - one with an object_id for the view and one with a different object_id for the table.
Is there any table that joins tables and views so that I might determine the underlying tables in a view?

 

[Andrzejek]

Can’t you just look at the script of the view

---- Andy

"Hmm...they have the internet on computers now"--Homer Simpson

 

[grnzbra]

This is for a script that compares one set of table/views with another set of table/views.

 

[iambob]

Not sure sorry.

Sincerely,
Bob Space

 

[iambob]

Something like this? (I'm brand new to SQL and don't know much, I barely even know the basics)

SELECT DISTINCT * FROM category here;

Sincerely,
Bob Space