This blog show how to query the lists in the current database along with the columns exposed
Example:
SELECT vs.name ViewName, cs.name ColumnName
FROM sys.columns cs INNER JOIN sys.views vs ON cs.object_id = vs.object_id
ORDER BY vs.name, cs.name
Loading

Join the conversation! Your thoughts help the community grow.