1051
CHAPTER 16
System Views
This chapter lists predefined views for the system tables.
The system tables described in "System Tables" on page 991 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.
Topic Page
SYSARTICLECOLS system view 1053
SYSARTICLES system view 1054
SYSCAPABILITIES system view 1055
SYSCATALOG system view 1056
SYSCOLAUTH system view 1057
SYSCOLUMNS system view 1058
SYSFOREIGNKEYS system view 1059
SYSGROUPS system view 1060
SYSINDEXES system view 1061
SYSOPTIONS system view 1062
SYSPROCAUTH system view 1063
SYSPROCPARMS system view 1064
SYSPUBLICATIONS system view 1065
SYSREMOTEOPTIONS system view 1066
SYSREMOTETYPES system views 1067
SYSREMOTEUSERS system view 1068
About this chapter
Contents
To Next Page
Loading...