I've tried to get the catalog information from "the other side". Looking for tables in syscomments and then joining to views.

select

v.name as View_Name,

t.name as Table_Name,

c.text as...