SQL Server: sys

Select all objects in sys

select
  v.name
from
  sys.schemas       s join
  sys.all_objects   v on s.schema_id = v.schema_id
where
  s.name = 'sys'
order by
  v.name;

Object types in sys

select
  count(*)       cnt,
  obj.type_desc  object_name
from
  sys.schemas     sch                                  join
  sys.all_objects obj on sch.schema_id = obj.schema_id
where
  sch.name = 'sys'
group by
  obj.type_desc;

Object views

TODO

See also