It seems that sys
catalog views can be found under every database, either built in or user created. Are they all actual view definitions created under each of the database or just "links" to somewhere?
Thanks
Where Are SQL Server Catalog Views Persisted?
sql serversystem-databasessystem-tablesview
Related Question
- SQL Server – Permissions Needed for Views Built on Other Views and Tables
- SQL Server 2017 Linux – Location of Resource Database on Disk
- SQL Server – SQL Script to Count Rows for All Views with SELECT-Only Access
- Sql-server – SQL Server 2016 – Disparity Between View Definition and View Design
- SQL Server – Grants for User to See All Tables and Views
Best Answer
Catalog views do not provide access to replication, SQL Server Agent, or backup metadata. Those are available in MSDB only.
Reference:
https://docs.microsoft.com/en-us/sql/relational-databases/databases/resource-database
https://technet.microsoft.com/en-us/library/ms179503(v=sql.105).aspx