SQL查询以列出SQL Server 2005数据库中的所有视图 [英] Sql Query to list all views in an SQL Server 2005 database

问题描述

我需要一个SQL查询来枚举SQL Server 2005中特定数据库的所有视图(我只需要视图名称).

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!

推荐答案

要完成出发(已经提出了建议):

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

SELECT * FROM sys.views

这为每个视图提供了额外的属性，而sys.objects(包含所有对象类型的公共属性)或INFORMATION_SCHEMA.VIEWS无法提供这些属性.尽管INFORMATION_SCHEMA方法确实提供了现成的视图定义.

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.

这篇关于SQL查询以列出SQL Server 2005数据库中的所有视图的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！