This chapter lists predefined views for the system tables.
The system tables described in System Tables use numbers to identify tables, user IDs, and so forth. While this is efficient for internal use, it makes these tables difficult for people to interpret. A number of predefined system views are provided that present the information in the system tables in a more readable format.
The definitions for the system views are included with their descriptions. Some of these definitions are complicated, but need not be understood to use the views. They serve as good examples of what can be accomplished using the SELECT command and views.
SYSARTICLECOLS system view
SYSARTICLES system view
SYSCATALOG system view
SYSCOLAUTH system view
SYSCOLUMNS system view
SYSFOREIGNKEYS system view
SYSGROUPS system view
SYSINDEXES system view
SYSOPTIONS system view
SYSPROCAUTH system view
SYSPROCPARMS system view
SYSPUBLICATIONS system view
SYSREMOTETYPES system views
SYSREMOTEUSERS system view
SYSSUBSCRIPTIONS system view
SYSTABAUTH system view
SYSTRIGGERS system view
SYSUSERAUTH system view
SYSUSERLIST system view
SYSUSEROPTIONS system view
SYSUSERPERMS system view
SYSVIEWS system view
Views for Transact-SQL Compatibility