In MS SQL, the following code should be run to get the list of all views in a database with a query.

SELECT * FROM sys.views