Search notes:

SQL Server: sys

sys.database_role_members shows membership of logins in database roles

sys.dm_exec_connections

sys.dm_exec_requests - information about executing requests

sys.dm_exec_sessions

sys.dm_os_performance_counters

sys.dm_server_registry

sys.dm_tran_locks

sys.dm_user_db_resource_governance

sys.external_data_sources

sys.foreign_keys

sys.foreign_key_columns

sys.indexes

sys.key_constraints

sys.login_token

sys.messages

sys.securable_classes

sys.server_permissions

sys.server_principals

sys.server_role_members shows membership of logins in server roles

sys.sql_expression_dependencies shows dependencies between database objects.

sys.sql_logins

sys.syscolumns

sys.syslanguages

sys.syslogins shows login accounts.

sys.sysmessages

sys.sysprocesses

sys.sql_modules

sys.systypes lists metadata about SQL Server data types.

sys.tables

sys.servers lists linked servers.

sys.trusted_assemblies

sys.user_token

sys.views

Select all objects in sys

The following query can be used to select all objects (such as tables, views etc.) in the sys schema.

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;

Github repository about-MSSQL, path: /administration/schemas/sys/select-objects.sql

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;

Github repository about-MSSQL, path: /administration/schemas/sys/object-types.sql

Object views

SQL Server: comparison of object views

TODO

There is also a sys.objects$ table from which the views sys.objects and sys.all_objects select.

SQL Server: sys

Select all objects in sys

Object types in sys

Object views

TODO

See also