sys.system_views (Transact-SQL)
Applies to: 
SQL Server
Azure SQL Managed Instance
Contains one row for each system view that is shipped with SQL Server. All system views are contained in the schemas named sys or INFORMATION_SCHEMA.
| 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. Will be reset 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. |
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)
DBCC CHECKDB (Transact-SQL)
DBCC CHECKTABLE (Transact-SQL)
ALTER ASSEMBLY (Transact-SQL)