Export (0) Print
Expand All
Expand Minimize

sys.all_views (Transact-SQL)

Shows the UNION of all user-defined and system views.

Applies to: SQL Server (SQL Server 2008 through current version), Azure SQL Database.

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 = Table 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.

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. For more information, see Metadata Visibility Configuration.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft