| | | In master only? |
| sysallocunits | Storage allocation units | ✗ |
| sysasymkeys | Asymmetric keys | ✗ |
| sysaudacts | | ? |
| sysbinobjs | Service Broker entities | ✗ |
| sysbinsubobjs | | ? |
| sysbrickfiles | | ? |
| syscerts | Certificates | ✗ |
| syschildinsts | | ? |
| sysclones | | ? |
| sysclsobjs | Classified entities | ✗ |
| syscolpars | Column names of tables, views and table-valued functions as well as parameter names of stored procedures and functions. | ✗ |
| syscompfragments | | ? |
| sysconvgroup | Sservice instance in Service Broker. | ✗ |
| syscscolsegments | | ? |
| syscsdictionaries | | ? |
| syscsrowgroups | | ? |
| sysdbfiles | ? | ✗ |
| sysdbfrag | | ? |
| sysdbreg | Registered databases | ✓ |
| sysdercv | Receiving endpoints of a Service Broker conversation | ✗ |
| sysdesend | Sending endpoints of a Service Broker conversation | ✗ |
| sysendpts | Endpoint created in the server. | ✓ |
| sysextendedrecoveryforks | | ? |
| sysextfileformats | | ? |
| sysextsources | | ? |
| sysexttables | | ? |
| sysfgfrag | | ? |
| sysfiles1 | lists the physical files for a database. | ✗ |
| sysfoqueues | | ? |
| sysfos | | ? |
| sysftinds | Full-text indeces | ✗ |
| sysftproperties | | ? |
| sysftsemanticsdb | | ? |
| sysftstops | | ? |
| sysguidrefs | GUIDs classified ID reference. | ✗ |
| sysidxstats | Index statistics (tables and indexed views) | ✗ |
| sysiscols | Persisted indices and statistics columns | ✗ |
| syslnklgns | Linked login mapping, used by remote procedure calls and distributed queries that emanate from a local server out to a corresponding linked server. | ✓ |
| syslogshippers | Database mirroring witnesses | ✓ |
| sysmatrixageforget | | ? |
| sysmatrixages | | ? |
| sysmatrixbricks | | ? |
| sysmatrixconfig | | ? |
| sysmatrixmanagers | | ? |
| sysmultiobjrefs | general N-to-N references | ✗ |
| sysmultiobjvalues | | ? |
| sysnsobjs | Namespace-scoped entities, used to store XML collection entities. | ✗ |
| sysobjkeycrypts | Symmetric keys, encryption or cryptographic property associated with an object. | ✗ |
| sysobjvalues | general value properties of entities | ✗ |
| sysowners | Each row represents a database principal. | ✗ |
| syspalnames (?) | This table is a bit of a mystery to me. It is not found in the sys.sysobjects view, however, I can select from this object name. | ? |
| sysphfg | | ? |
| syspriorities | | ? |
| sysprivs | Database- or server-level permissions. (Server-level permissions are stored in the master database). | ✗ |
| syspru | | ? |
| sysqnames | Namespace or qualified name to a 4-byte ID token. | ✗ |
| sysremsvcbinds | Remote service bindings | ✗ |
| sysrmtlgns | Remote login mappings, used to map incoming logins that claim to be coming from a corresponding server to an actual local login. | ✓ |
| sysrowsetrefs | Indeces to rowset references | ✗ |
| sysrowsets | Partition rowsets for an index or a heap | ✗ |
| sysrscols | | ? |
| sysrts | | ? |
| sysscalartypes | Types (user-defined and system types) | ✗ |
| sysschobjs | Objects in a database | ✗ |
| sysseobjvalues | | ? |
| syssingleobjrefs | general N-to-1 references | ✗ |
| syssoftobjrefs | | ? |
| syssqlguides | | ? |
| systypedsubobjs | Typed subentities (currently only parameters for partition functions) | ✗ |
| sysusermsgs | User-defined error messages | ✓ |
| syswebmethods | SOAP-methods defined on a SOAP-enabled HTTP endpoint that is created in the server. | ✓ |
| sysxlgns | Server principals | ✓ |
| sysxmitbody | | ? |
| sysxmitqueue | Service Broker transmission queues | ✗ |
| sysxmlcomponent | XML schema components | ✗ |
| sysxmlfacet | XML facets (restriction) of XML type definition | ✗ |
| sysxmlplacement | XML placements for XML components. | ✗ |
| sysxprops | Extended properties | ✗ |
| sysxsrvs | Lists local, linked and remote servers | ✓ |
Dollar ($) suffix
Apparently, such
system base tables can also be queried with a dollar (
$) suffix. The following two
SQL Statements return nothing:
select * from sys.sysschobjs$ except
select * from sys.sysschobjs;
select * from sys.sysschobjs except
select * from sys.sysschobjs$;