How to List all Views in a SQL Server Database

To list all views in a SQL Server Database, run the following code that checks the INFORMATION_SCHEMA.TABLES view:

USE Database_Name
SELECT * FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_TYPE ='VIEW'

list_all_views_in_a_database

Read related blog post:
How to check if the View exists in a SQL Server Database