SQL Server Transact Basic to Expert - Query to list the views in the database

SQL Server Transact Basic to Expert - Query to list the views in the database

This blog show how to query the database to see the list of views used with view names

Example:

SELECT   s.name SchemaName,  vs.name ViewName FROM sys.views vs
INNER JOIN
sys.schemas sc ON vs.schema_id = sc.schema_id
ORDER BY sc.name, vs.name