Provided here you will find two SQL queries to allow you to list all of the Views from a specified SQL Database.
The first query uses the Tables Schema and the second one uses the Views Schema.
SQL Query: Tables Schema
Select
Table_Name
From Information_Schema.Tables
Where Table_Type = 'View'
Order By Table_Name
SQL Query: Views Schema
From Information_Schema.Views
No Comments