Sql Query to list all views in an SQL Server 2005 database

sql sql-server metadata
Mats picture Mats · May 25, 2010 · Viewed 148.8k times · Source

I need an sql query to enumerate all views (I only need the view names) of a specific database in SQL Server 2005. Thanks in advance!

Answer

AdaTheDev picture AdaTheDev · May 25, 2010

To finish the set off (with what has already been suggested):

SELECT * FROM sys.views

This gives extra properties on each view, not available from sys.objects (which contains properties common to all types of object) or INFORMATION_SCHEMA.VIEWS. Though INFORMATION_SCHEMA approach does provide the view definition out-of-the-box.

Related questions

SQL Server: Extract Table Meta-Data (description, fields and their data types)

I am trying to find a way to extract information about my tables in SQL Server (2008). The data I need needs to include the description of the table (filled from the Description property in the Properties Window), a list of …

Read More
SQL Server: should I use information_schema tables over sys tables?

In SQL Server there is two schemas for metadata: INFORMATION_SCHEMA SYS I have heard that INFORMATION_SCHEMA tables are based on ANSI standard. When developing e.g. stored procedures, should it be wise to use INFORMATION_SCHEMA tables over …

Read More
How to Check all stored procedure is ok in sql server?

How to check all stored procedure is ok in sql server if I drop a table or fields?

Read More