ASA SQL Reference
System Views
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.
System view definitions
SYSARTICLECOLS system view
SYSARTICLES system view
SYSCAPABILITIES system view
SYSCATALOG system view
SYSCOLAUTH system view
SYSCOLSTATS system view
SYSCOLUMNS system view
SYSFOREIGNKEYS system view
SYSGROUPS system view
SYSINDEXES system view
SYSOPTIONS system view
SYSOPTORDERS system view
SYSOPTPLANS system view
SYSOPTSTRATEGIES system view
SYSPROCAUTH system view
SYSPROCPARMS system view
SYSPUBLICATIONS system view
SYSREMOTEOPTION2 system view
SYSREMOTEOPTIONS system view
SYSREMOTETYPES system view
SYSREMOTEUSERS system view
SYSSUBSCRIPTIONS system view
SYSSYNCDEFINITIONS system view
SYSSSYNCPUBLICATIONDEFAULTS system view
SYSSYNC2 system view
SYSSSYNCS system view
SYSSYNCSITES system view
SYSSYNCSUBSCRIPTIONS system view
SYSSYNCTEMPLATES system view
SYSSYNCUSERS system view
SYSTABAUTH system view
SYSTRIGGERS system view
SYSUSERAUTH system view
SYSUSERLIST system view
SYSUSEROPTIONS system view
SYSUSERPERMS system view
SYSVIEWS system view