A system table or catalog table that stores “System Objects” is called sys.objects. Every user-defined, schema-scoped object that is created in a database is represented
Tag: sys.objects in SQL Server
Fetch all the views – SQL Server
The following commands will assist in retrieving the metadata details regarding the system-created views. SELECT * FROM sys.objects WHERE type = ‘V’ Or you can