Sybase 12.4.2 User Manual
Page 35
![background image](/manuals/85803/35/background.png)
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