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

Ebook Download
View all
Learn
View all