sys.views (Transact-SQL)
Applies to: SQL Server Azure SQL Database Azure SQL Managed Instance Azure Synapse Analytics Analytics Platform System (PDW)
Contains a row for each view object, with sys.objects.type = V.
Column name | Data type | Description |
---|---|---|
<inherited columns> | For a list of columns that this view inherits, see sys.objects (Transact-SQL) | |
is_replicated | bit | 1 = View is replicated. |
has_replication_filter | bit | 1 = View has a replication filter. |
has_opaque_metadata | bit | 1 = VIEW_METADATA option specified for view. For more information, see CREATE VIEW (Transact-SQL). |
has_unchecked_assembly_data | bit | 1 = View contains persisted data that depends on an assembly whose definition changed during the last ALTER ASSEMBLY. Resets to 0 after the next successful DBCC CHECKDB or DBCC CHECKTABLE. |
with_check_option | bit | 1 = WITH CHECK OPTION was specified in the view definition. |
is_date_correlation_view | bit | 1 = View was created automatically by the system to store correlation information between datetime columns. Creation of this view was enabled by setting DATE_CORRELATION_OPTIMIZATION to ON. |
ledger_view_type | tinyint | Applies to: Starting with SQL Server 2022 (16.x), Azure SQL Database. The numeric value indicating if a view is a ledger view for an updatable ledger table. 0 = NON_LEDGER_VIEW 1 = LEDGER_VIEW For more information on database ledger, see Ledger. |
ledger_view_type_desc | nvarchar(60) | Applies to: Starting with SQL Server 2022 (16.x), Azure SQL Database. The text description of a value in the ledger_view_type column: NON_LEDGER_VIEW LEDGER_VIEW |
is_dropped_ledger_view | bit | Applies to: Starting with SQL Server 2022 (16.x), Azure SQL Database. Indicates a ledger view that has been dropped. |
Permissions
The visibility of the metadata in catalog views is limited to securables that a user either owns, or on which the user was granted some permission. For more information, see Metadata Visibility Configuration.
See Also
Object Catalog Views (Transact-SQL)
Catalog Views (Transact-SQL)
ALTER ASSEMBLY (Transact-SQL)
DBCC CHECKDB (Transact-SQL)
DBCC CHECKTABLE (Transact-SQL)
Querying the SQL Server System Catalog FAQ
Phản hồi
https://aka.ms/ContentUserFeedback.
Sắp ra mắt: Trong năm 2024, chúng tôi sẽ dần gỡ bỏ Sự cố với GitHub dưới dạng cơ chế phản hồi cho nội dung và thay thế bằng hệ thống phản hồi mới. Để biết thêm thông tin, hãy xem:Gửi và xem ý kiến phản hồi dành cho