Consolidated views

Consolidated views provide data in a form more frequently required by users. For example, consolidated views often provide commonly-needed joins. Consolidated views differ from system views in that they are not just a straight forward view of raw data in a underlying system table(s). For example, many of the columns in the system views are unintelligible ID values, whereas in the consolidated views, they are readable names.


SYSARTICLECOLS consolidated view
SYSARTICLES consolidated view
SYSCAPABILITIES consolidated view
SYSCATALOG consolidated view
SYSCOLAUTH consolidated view
SYSCOLSTATS consolidated view
SYSCOLUMNS consolidated view
SYSFOREIGNKEYS consolidated view
SYSGROUPS consolidated view
SYSINDEXES consolidated view
SYSOPTIONS consolidated view
SYSPROCAUTH consolidated view
SYSPROCPARMS consolidated view
SYSPROCS consolidated view
SYSPUBLICATIONS consolidated view
SYSREMOTEOPTION2 consolidated view
SYSREMOTEOPTIONS consolidated view
SYSREMOTETYPES consolidated view
SYSREMOTEUSERS consolidated view
SYSSUBSCRIPTIONS consolidated view
SYSSYNC2 consolidated view
SYSSYNCPUBLICATIONDEFAULTS consolidated view
SYSSYNCS consolidated view
SYSSYNCSCRIPTS consolidated view
SYSSYNCSUBSCRIPTIONS consolidated view
SYSSYNCUSERS consolidated view
SYSTABAUTH consolidated view
SYSTRIGGERS consolidated view
SYSUSEROPTIONS consolidated view
SYSVIEWS consolidated view