SQL Server Transact Basic to Expert - Query to list the views in the database along with exposed columns
SQL Server Transact Basic to Expert - Query to list the views in the database along with exposed columns
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