Filter
Top Products
CHAPTER 1 Overview of Adaptive Server IQ System Administration
15
For a complete description of system tables and views and their contents, see
the Adaptive Server IQ Reference Manual.
System view Description
SYSCATALOG Lists all tables and views from
SYSTABLE
SYSCOLAUTH Presents column update permission
information from SYSCOLPERM
SYSCOLUMNS Presents a readable version of the table
SYSCOLUMN
SYSFOREIGNKEYS Presents foreign key information from
SYSFOREIGNKEY and SYSFKCOL
SYSGROUPS Presents group information from
SYSGROUP
SYSINDEXES Presents index information from
SYSINDEX and SYSIXCOL
SYSOPTIONS Displays option settings contained in
the table SYSOPTION
SYSPROCPARMS Lists all the procedure parameters
from SYSPROCPARM
SYSREMOTEUSERS Lists the information in
SYSREMOTEUSER
SYSTABAUTH Presents table permission information
in SYSTABLEPERM
SYSUSERAUTH Displays all the information in the
table SYSUSERPERM except for user
numbers. Because it contains
passwords, this system view does not
have PUBLIC select permission
SYSUSERLIST Presents all information in
SYSUSERAUTH except for
passwords
SYSUSEROPTIONS Display effective permanent option
settings for each user
SYSUSERPERMS Contains exactly the same information
as the table SYS.SYSUSERPERM
except the password is omitted
SYSVIEWS Lists views and their definitions