Filter
Top Products
System tables and views
14
System views present the information from their corresponding system tables
in a more readable format. In some cases, they omit password information so
that they can be accessible to all users. System views include:
SYSLOGIN Lists User Profile names that can
connect to the database with an
integrated login
SYSOPTION Lists current SET OPTION settings
for all users including the PUBLIC
user
SYSPROCEDURE Describes each procedure in the
database
SYSPROCPARM Describes each parameter to every
procedure in the database
SYSPROCPERM Lists each user granted permission to
call each procedure in the database
SYSPUBLICATION Describes each SQL Remote
publication
SYSREMOTETYPE Contains information about SQL
Remote
SYSREMOTEUSER Describes user IDs with REMOTE
permissions and the status of their
SQL Remote messages
SYSSQLSERVERTYPE Contains information relating to
compatibility with Adaptive Server
Enterprise
SYSSUBSCRIPTION Relates each user ID with REMOTE
permissions to a publication
SYSTABLE Describes one table or view in the
database
SYSTABLEPERM Describes permissions granted on
each table in the database
SYSSQLSERVERTYPE Contains information on compatibility
with Adaptive Server Enterprise
SYSUSERMESSAGES Lists user-defined error messages and
their creators
SYSUSERPERM Lists characteristics of each user ID.
Because it contains passwords, you
need DBA permissions to select from
this table
SYSUSERTYPE Describes each user-defined data type
System table Description