sys.views (Transact-SQL)sys.views (Transact-SQL)

適用於: 是SQL Server 是Azure SQL Database 是Azure SQL 資料倉儲 是平行處理資料倉儲 APPLIES TO: yesSQL Server yesAzure SQL Database yesAzure SQL Data Warehouse yesParallel Data Warehouse

包含每個檢視物件,一個資料列具有sys.objects.type = V。Contains a row for each view object, with sys.objects.type = V.

資料行名稱Column name 資料類型Data type 描述Description
<繼承資料行 ><inherited columns> 如需這個檢視所繼承的資料行的清單,請參閱 < j (TRANSACT-SQL)For a list of columns that this view inherits, see sys.objects (Transact-SQL)
is_replicatedis_replicated bitbit 1 = 檢視已被複寫。1 = View is replicated.
has_replication_filterhas_replication_filter bitbit 1 = 檢視具有複寫篩選。1 = View has a replication filter.
has_opaque_metadatahas_opaque_metadata bitbit 1 = 針對檢視所指定的 VIEW_METADATA 選項。1 = VIEW_METADATA option specified for view. 如需詳細資訊,請參閱 CREATE VIEW (Transact-SQL)For more information, see CREATE VIEW (Transact-SQL).
has_unchecked_assembly_datahas_unchecked_assembly_data bitbit 1 = 檢視包含保存資料,這些保存資料會隨著上次 ALTER ASSEMBLY 期間變更定義的組件而不同。1 = View contains persisted data that depends on an assembly whose definition changed during the last ALTER ASSEMBLY. 它會在下次 DBCC CHECKDB 或 DBCC CHECKTABLE 順利完成之後,重設為 0。Resets to 0 after the next successful DBCC CHECKDB or DBCC CHECKTABLE.
with_check_optionwith_check_option bitbit 1 = WITH CHECK OPTION 是在檢視定義中指定。1 = WITH CHECK OPTION was specified in the view definition.
is_date_correlation_viewis_date_correlation_view bitbit 1 = 檢視是由系統自動建立,以儲存 datetime 資料行之間的相互關聯資訊。1 = View was created automatically by the system to store correlation information between datetime columns. 若要建立這份檢視,請將 DATE_CORRELATION_OPTIMIZATION 設為 ON。Creation of this view was enabled by setting DATE_CORRELATION_OPTIMIZATION to ON.

PermissionsPermissions

目錄檢視內中繼資料的可見性會限制在使用者所擁有的安全性實體,或已授與使用者某些權限的安全性實體。The visibility of the metadata in catalog views is limited to securables that a user either owns or on which the user has been granted some permission. 如需相關資訊,請參閱 Metadata Visibility ConfigurationFor more information, see Metadata Visibility Configuration.

另請參閱See Also

物件目錄檢視 (Transact-SQL) Object Catalog Views (Transact-SQL)
目錄檢視 (Transact-SQL) Catalog Views (Transact-SQL)
ALTER ASSEMBLY (Transact-SQL) ALTER ASSEMBLY (Transact-SQL)
DBCC CHECKDB (Transact-SQL) DBCC CHECKDB (Transact-SQL)
DBCC CHECKTABLE (Transact-SQL) DBCC CHECKTABLE (Transact-SQL)
查詢 SQL Server 系統目錄常見問題集Querying the SQL Server System Catalog FAQ