System Views

Use the system views to view the contents of the system tables.

A number of predefined system views are provided that present the information in the system tables in a readable format.

The definitions for the system views are included with their descriptions. Some of these definitions are complicated, but you do not need to understand them to use the views.

• Consolidated Views
  Consolidated views provide data in a form more frequently required by users.
• Compatibility Views
  Compatibility views are deprecated views provided for compatibility with earlier versions of SQL Anywhere and Sybase IQ.
• ASE T-SQL Compatibility Views
  Sybase IQ provides a set of views owned by the special user DBO, which correspond to the Adaptive Server Enterprise system tables and views.
• SYSARTICLE system view
  Each row of the SYSARTICLE system view describes an article in a publication. The underlying system table for this view is ISYSARTICLE.
• SYSARTICLECOL system view
  Each row of the SYSARTICLECOL system view identifies a column in an article. The underlying system table for this view is ISYSARTICLECOL.
• SYSARTICLECOLS consolidated view
  Each row in the SYSARTICLECOLS view identifies a column in an article.
• SYSARTICLES consolidated view
  Each row in the SYSARTICLES view describes an article in a publication.
• SYSCAPABILITIES consolidated view
  Each row in the SYSCAPABILITIES view specifies the status of a capability for a remote database server. This view gets its data from the ISYSCAPABILITY and ISYSCAPABILITYNAME system tables.
• SYSCAPABILITY system view
  Each row of the SYSCAPABILITY system view specifies the status of a capability on a remote database server. The underlying system table for this view is ISYSCAPABILITY.
• SYSCAPABILITYNAME system view
  Each row in the SYSCAPABILITYNAME system view provides a name for each capability ID in the SYSCAPABILITY system view.
• SYSCATALOG consolidated view
  Each row in the SYSCATALOG view describes a system table.
• SYSCHECK system view
  Each row in the SYSCHECK system view provides the definition for a named check constraint in a table. The underlying system table for this view is ISYSCHECK.
• SYSCOLAUTH consolidated view
  Each row in the SYSCOLAUTH view describes the set of privileges (UPDATE, SELECT, or REFERENCES) granted on a column.
• SYSCOLLATION compatibility view (deprecated)
  The SYSCOLLATION compatibility view contains the collation sequence information for the database. It is obtainable via built-in functions and is not kept in the catalog. Following is definition for this view:
• SYSCOLLATIONMAPPINGS compatibility view (deprecated)
  The SYSCOLLATIONMAPPINGS compatibility view contains only one row with the database collation mapping. It is obtainable via built-in functions and is not kept in the catalog. Following is definition for this view:
• SYSCOLPERM system view
  The GRANT statement can give UPDATE, SELECT, or REFERENCES permission to individual columns in a table. Each column with UPDATE, SELECT, or REFERENCES permission is recorded in one row of the SYSCOLPERM system view. The underlying system table for this view is ISYSCOLPERM.
• SYSCOLSTAT system view
  The SYSCOLSTAT system view contains the column statistics, including histograms, that are used by the optimizer. The contents of this view are best retrieved using the sa_get_histogram stored procedure or the Histogram utility. The underlying system table for this view is ISYSCOLSTAT.
• SYSCOLSTATS consolidated view
  The SYSCOLSTATS view contains the column statistics that are stored as histograms and used by the optimizer.
• SYSCOLUMN compatibility view (deprecated)
  The SYSCOLUMN view is provided for compatibility with older versions of the software that offered a SYSCOLUMN system table. However, the previous SYSCOLUMN table has been replaced by the ISYSTABCOL system table, and its corresponding SYSTABCOL system view, which you should use instead.
• SYSCOLUMNS consolidated view
  Each row in the SYSCOLUMNS view describes one column of each table and view in the catalog.
• SYSCOLUMNS ASE Compatibility View
  This view is owned by user DBO. syscolumns contains one row for every column in every table and view, and a row for each parameter in a procedure.
• SYSCOMMENTS ASE Compatibility View
  syscomments contains entries for each view, rule, default, trigger, table constraint, partition, procedure, computed column, function-based index key, and other forms of compiled objects.
• SYSCONSTRAINT system view
  Each row in the SYSCONSTRAINT system view describes a named constraint in the database. The underlying system table for this view is ISYSCONSTRAINT.
• SYSDBFILE system view
  Each row in the SYSDBFILE system view describes a dbspace file. The underlying system table for this view is ISYSDBFILE.
• SYSDBSPACE system view
  Each row in the SYSDBSPACE system view describes a dbspace file. The underlying system table for this view is ISYSDBSPACE.
• SYSDBSPACEPERM System View
  Each row in the SYSDBSPACEPERM system view describes a permission on a dbspace file. The underlying system table for this view is ISYSDBSPACEPERM.
• SYSDEPENDENCY system view
  Each row in the SYSDEPENDENCY system view describes a dependency between two database objects. The underlying system table for this view is ISYSDEPENDENCY.
• SYSDOMAIN system view
  The SYSDOMAIN system view records information about built-in data types (also called domains). The contents of this view does not change during normal operation. The underlying system table for this view is ISYSDOMAIN.
• SYSEVENT system view
  Each row in the SYSEVENT system view describes an event created with CREATE EVENT. The underlying system table for this view is ISYSEVENT.
• SYSEVENTTYPE System View
  The SYSEVENTTYPE system view defines the system event types that can be referenced by CREATE EVENT.
• SYSEXTERNENV system view
  Many external runtime environments are supported, including embedded SQL and ODBC applications written in C/C++, and applications written in Java, Perl, PHP, or languages such as C# and Visual Basic that are based on the Microsoft .NET Framework Common Language Runtime (CLR).
• SYSEXTERNENVOBJECT system view
  Many external runtime environments are supported, including embedded SQL and ODBC applications written in C/C++, and applications written in Java, Perl, PHP, or languages such as C# and Visual Basic that are based on the Microsoft .NET Framework Common Language Runtime (CLR).
• SYSEXTERNLOGIN system view
  Each row in the SYSEXTERNLOGIN system view describes an external login for remote data access. The underlying system table for this view is ISYSEXTERNLOGIN.
• SYSFILE compatibility view (deprecated)
  Each row in the SYSFILE system view describes a dbspace for a database. Every database consists of one or more dbspaces; each dbspace corresponds to an operating system file.
• SYSFKCOL compatibility view (deprecated)
  Each row of SYSFKCOL describes the association between a foreign column in the foreign table of a relationship and the primary column in the primary table. This view is deprecated; use the SYSIDX and SYSIDXCOL system views instead.
• SYSFKEY system view
  Each row in the SYSFKEY system view describes a foreign key constraint in the system. The underlying system table for this view is ISYSFKEY.
• SYSFOREIGNKEY compatibility view (deprecated)
  The SYSFOREIGNKEY view is provided for compatibility with older versions of the software that offered a SYSFOREIGNKEY system table. However, the previous SYSFOREIGNKEY system table has been replaced by the ISYSFKEY system table, and its corresponding SYSFKEY system view, which you should use instead.
• SYSFOREIGNKEYS consolidated view
  Each row in the SYSFOREIGNKEYS view describes one foreign key for each table in the catalog.
• SYSGROUP system view
  There is one row in the SYSGROUP system view for each member of each group. This view describes the many-to-many relationship between groups and members. A group may have many members, and a user may be a member of many groups. The underlying system table for this view is ISYSGROUP.
• SYSGROUPS consolidated view
  There is one row in the SYSGROUPS view for each member of each group. This view describes the many-to-many relationship between groups and members. A group may have many members, and a user may be a member of many groups.
• SYSHISTORY system view
  Each row in the SYSHISTORY system view records a system operation on the database, such as a database start, a database calibration, and so on. The underlying system table for this view is ISYSHISTORY.
• SYSIDX system view
  Each row in the SYSIDX system view defines a logical index in the database. The underlying system table for this view is ISYSIDX.
• SYSIDXCOL system view
  Each row in the SYSIDXCOL system view describes one column of an index described in the SYSIDX system view. The underlying system table for this view is ISYSIDXCOL.
• SYSINDEX compatibility view (deprecated)
  The SYSINDEX view is provided for compatibility with older versions of the software that offered a SYSINDEX system table. However, the SYSINDEX system table has been replaced by the ISYSIDX system table, and its corresponding SYSIDX system view, which you should use instead.
• SYSINDEXES consolidated view
  Each row in the SYSINDEXES view describes one index in the database. As an alternative to this view, you could also use the SYSIDX and SYSIDXCOL system views.
• SYSINDEXES ASE Compatibility View
  sysindexes contains one row for each clustered index, one row for each nonclustered index, one row for each table that has no clustered index, and one row for each table that contains text or image columns.
• SYSINFO compatibility view (deprecated)
  The SYSINFO view indicates the database characteristics, as defined when the database was created. It always contains only one row. This view is obtainable via built-in functions and is not kept in the catalog. Following is the definition for the SYSINFO view:
• SYSIQBACKUPHISTORY System View
  This view presents group information from ISYSIQBACKUPHISTORY in a readable format. Each row in this view describes a particular backup operation that finished successfully.
• SYSIQBACKUPHISTORYDETAIL System View
  This view describes all the dbfile records present in the database at backup time. Each row in this view describes a particular backup operation that finished successfully.
• SYSIQCOLUMN System View (Deprecated)
  SYSIQCOLUMN has been replaced by the SYSIQTABCOL system view.
• SYSIQDBFILE System View
  Presents group information from ISYSIQDBFILE in a readable format.
• SYSIQDBSPACE System View
  Presents group information from ISYSIQDBSPACE in a readable format.
• SYSIQFILE System View (Deprecated)
  SYSIQFILE has been replaced by the SYSIQDBFILE system view.
• SYSIQIDX System View
  Presents group information from ISYSIQIDX in a readable format. Each row in the SYSIQIDX view describes an IQ index.
• SYSIQINFO System View
  Presents group information from ISYSIQINFO in a readable format.
• SYSIQJOINIDX System View
  Presents group information from ISYSIQJOINIDX in a readable format. Each row in the SYSIQJOINIDX view describes an IQ join index.
• SYSIQJOININDEX System View (Deprecated)
  SYSIQJOININDEX has been replaced by the SYSIQJOINIDX system view.
• SYSIQJOINIXCOLUMN System View
  Presents group information from ISYSIQJOINIXCOLUMN in a readable format. Each row in the SYSIQJOINIXCOLUMN view describes an IQ join index.
• SYSIQJOINIXTABLE System View
  Presents group information from ISYSIQJOINIXTABLE in a readable format. Each row in the SYSIQJOINIXTABLE view describes an IQ join index.
• SYSIQLOGICALSERVER System View
  Presents information from the ISYSIQLOGICALSERVER table, which stores the logical server and the correspondence between logical server and associated logical server policy information.
• SYSIQLOGINPOLICYLSINFO System View
  Presents group information from the ISYSIQLOGINPOLICYLSINFO table, which stores the login policy logical server assignment information.
• SYSIQLSLOGINPOLICYOPTION System View
  Presents group information from the ISYSIQLOGINPOLICYLSINFO table, which stores the login policy logical server assignment information.
• SYSIQLSMEMBER System View
  Presents group information from the ISYSIQLSMEMBER table, which stores the logical server membership information.
• SYSIQLSMEMBERS Consolidated View
  This view describes all user-defined logical server memberships.
• SYSIQLSLOGINPOLICIES Consolidated View
  This view describes all the logical server assignments from the login policies.
• SYSIQLSPOLICY System View
  Presents group information from the ISYSIQLSPOLICY table, which stores the logical server policies.
• SYSIQLSPOLICYOPTION System View
  Presents group information from the ISYSIQLSPOLICYOPTION table, which stores the logical server policy options.
• SYSIQMPXSERVER System View
  Presents a readable version of the table ISYSIQMPXSERVER, which stores membership properties and version status data for the given multiplex node.
• SYSIQOBJECTS ASE Compatibility View
  sysiqobjects presents one row for each system table, user table, view, procedure, trigger, event, join index, constraint, domain (sysdomain), domain (sysusertype), column, and index. This view is owned by user DBO.
• SYSIQPARTITIONCOLUMN System View
  Presents group information from ISYSIQPARTITIONCOLUMN in a readable format.
• SYSIQTAB System View
  Presents group information from ISYSIQTAB in a readable format. Each row in the SYSIQTAB view describes an IQ table.
• SYSIQTABCOL System View
  Presents group information from ISYSIQTABCOL in a readable format. Each row in the SYSIQTABCOL view describes a column in an IQ table.
• SYSIQTABLE System View (Deprecated)
  SYSIQTABLE has been replaced by the SYSIQTAB system view.
• SYSIQVINDEX ASE Compatibility View
  sysiqvindex provides one row for each non-FP IQ index.
• SYSIXCOL compatibility view (deprecated)
  The SYSIXCOL view is provided for compatibility with older versions of the software that offered a SYSIXCOL system table. However, the SYSIXCOL system table has been replaced by the ISYSIDXCOL system table, and its corresponding SYSIDXCOL system view. You should switch to using the SYSIDXCOL system view.
• SYSJAR system view
  Each row in the SYSJAR system view defines a JAR file stored in the database. The underlying system table for this view is ISYSJAR.
• SYSJARCOMPONENT system view
  Each row in the SYSJAR system view defines a JAR file component. The underlying system table for this view is ISYSJARCOMPONENT.
• SYSJAVACLASS system view
  Each row in the SYSJAVACLASS system view describes one Java class stored in the database. The underlying system table for this view is ISYSJAVACLASS.
• SYSLOGINMAP system view
  The SYSLOGINMAP system view contains one row for each user that can connect to the database using either an integrated login, or Kerberos login. As a security measure, only users with DBA authority can view the contents of this view. The underlying system table for this view is ISYSLOGINMAP.
• SYSLOGINPOLICY system view
  The underlying system table for this view is ISYSLOGINPOLICY.
• SYSLOGINPOLICYOPTION system view
  The underlying system table for this view is ISYSLOGINPOLICYOPTION.
• SYSLOGINS ASE Compatibility View
  This view is owned by user DBO. syslogins contains one row for each valid Adaptive Server Enterprise user account.
• SYSMVOPTION system view
  Each row in the SYSMVOPTION system view describes the setting of one option value for a materialized view or text index at the time of its creation. The name of the option can be found in the SYSMVOPTIONNAME system view. The underlying system table for this view is ISYSMVOPTION.
• SYSMVOPTIONNAME system view
  Each row in the SYSMVOPTION system view gives the name option value for a materialized view or text index at the time of its creation. The value for the option can be found in the SYSMVOPTION system view. The underlying system table for this view is ISYSMVOPTIONNAME.
• SYSOBJECT system view
  Each row in the SYSOBJECT system view describes a database object. The underlying system table for this view is ISYSOBJECT.
• SYSOBJECTS ASE Compatibility View
  sysobjects contains one row for each table, view, stored procedure, extended stored procedure, log, rule, default, trigger, check constraint, referential constraint, computed column, function-based index key, and temporary object, and other forms of compiled objects.
• SYSOPTION system view
  The SYSOPTION system view contains the options one row for each option setting stored in the database. Each user can have their own setting for a given option. In addition, settings for the PUBLIC user ID define the default settings to be used for users that do not have their own setting. The underlying system table for this view is ISYSOPTION.
• SYSOPTIONS consolidated view
  Each row in the SYSOPTIONS view describes one option created using the SET command. Each user can have their own setting for each option. In addition, settings for the PUBLIC user define the default settings to be used for users that do not have their own setting.
• SYSOPTSTAT system view
  The SYSOPTSTAT system view stores the cost model calibration information as computed by the ALTER DATABASE CALIBRATE statement. The contents of this view are for internal use only and are best accessed via the sa_get_dtt system procedure. The underlying system table for this view is ISYSOPTSTAT.
• SYSPARTITION System View
  Presents group information from ISYSPARTITION in a readable format.
• SYSPARTITIONKEY System View
  Presents group information from ISYSPARTITIONKEY in a readable format.
• SYSPARTITIONSCHEME System View
  Presents group information from ISYSPARTITIONSCHEME in a readable format.
• SYSPHYSIDX system view
  Each row in the SYSPHYSIDX system view defines a physical index in the database. The underlying system table for this view is ISYSPHYSIDX.
• SYSPROCAUTH consolidated view
  Each row in the SYSPROCAUTH view describes a set of privileges granted on a procedure. As an alternative, you can also use the SYSPROCPERM system view.
• SYSPROCEDURE system view
  Each row in the SYSPROCEDURE system view describes one procedure in the database. The underlying system table for this view is ISYSPROCEDURE.
• SYSPROCPARM system view
  Each row in the SYSPROCPARM system view describes one parameter to a procedure in the database. The underlying system table for this view is ISYSPROCPARM.
• SYSPROCPARMS consolidated view
  Each row in the SYSPROCPARMS view describes a parameter to a procedure in the database.
• SYSPROCPERM system view
  Each row of the SYSPROCPERM system view describes a user granted permission to execute a procedure. Only users who have been granted permission can execute a procedure. The underlying system table for this view is ISYSPROCPERM.
• SYSPROCS consolidated view
  The SYSPROCS view shows the procedure or function name, the name of its creator and any comments recorded for the procedure or function.
• SYSPROXYTAB system view
  Each row of the SYSPROXYTAB system view describes the remote parameters of one proxy table. The underlying system table for this view is ISYSPROXYTAB.
• SYSPUBLICATION system view
  Each row in the SYSPUBLICATION system view describes a publication. The underlying system table for this view is ISYSPUBLICATION.
• SYSPUBLICATIONS consolidated view
  Each row in the SYSPUBLICATIONS view describes a publication.
• SYSREMARK system view
  Each row in the SYSREMARK system view describes a remark (or comment) for an object. The underlying system table for this view is ISYSREMARK.
• SYSREMOTEOPTION System View
  Each row in the SYSREMOTEOPTION system view describes the value of a SQL Remote message link parameter. The underlying system table for this view is ISYSREMOTEOPTION.
• SYSREMOTEOPTION2 consolidated view
  Presents, in a more readable format, the columns from SYSREMOTEOPTION and SYSREMOTEOPTIONTYPE that do not contain sensitive data.
• SYSREMOTEOPTIONS consolidated view
  Each row of the SYSREMOTEOPTIONS view describes the values of a message link parameter. Some columns in this view contain potentially sensitive data. For that reason, access to this view is restricted to users with DBA authority. The SYSREMOTEOPTION2 view provides public access to the insensitive data.
• SYSREMOTEOPTIONTYPE system view
  Each row in the SYSREMOTEOPTIONTYPE system view describes one of the message link parameters. The underlying system table for this view is ISYSREMOTEOPTIONTYPE.
• SYSREMOTETYPE system view
  The SYSREMOTETYPE system view contains information about SQL Remote. The underlying system table for this view is ISYSREMOTETYPE.
• SYSREMOTETYPES consolidated view
  Each row of the SYSREMOTETYPES view describes one of the message types, including the publisher address.
• SYSREMOTEUSER system view
  Each row in the SYSREMOTEUSER system view describes a user ID with REMOTE permissions (a subscriber), together with the status of messages that were sent to and from that user. The underlying system table for this view is ISYSREMOTEUSER.
• SYSREMOTEUSERS consolidated view
  Each row of the SYSREMOTEUSERS view describes a user ID with REMOTE permissions (a subscriber), together with the status of messages that were sent to and from that user.
• SYSSCHEDULE System View
  Each row in the SYSSCHEDULE system view describes a time at which an event is to fire, as specified by the SCHEDULE clause of CREATE EVENT.
• SYSSERVER system view
  Each row in the SYSSERVER system view describes a remote server. The underlying system table for this view is ISYSSERVER.
• SYSSOURCE system view
  Each row in the SYSSOURCE system view contains the source code, if applicable, for an object listed in the SYSOBJECT system view. The underlying system table for this view is ISYSSOURCE.
• SYSSQLSERVERTYPE system view
  The SYSSQLSERVERTYPE system view contains information relating to compatibility with Adaptive Server Enterprise. The underlying system table for this view is ISYSSQLSERVERTYPE.
• SYSSUBPARTITIONKEY System View
  This view is reserved for future use. Sybase IQ 15.4 does not support subpartitioning.
• SYSSUBSCRIPTION system view
  Each row in the SYSSUBSCRIPTION system view describes a subscription from one user ID (which must have REMOTE permissions) to one publication. The underlying system table for this view is ISYSSUBSCRIPTION.
• SYSSUBSCRIPTIONS consolidated view
  Each row describes a subscription from one user ID (which must have REMOTE permissions) to one publication.
• SYSSYNC system view
  The SYSSYNC system view contains information relating to synchronization. Some columns in this view contain potentially sensitive data. For that reason, access to this view is restricted to users with DBA authority. The SYSSYNC2 view provides public access to the data in this view except for the potentially sensitive columns. The underlying system table for this view is ISYSSYNC.
• SYSSYNC2 consolidated view
  The SYSSYNC2 view provides public access to the data found in the SYSSYNC system view—information relating to synchronization—without exposing potentially sensitive data.
• SYSSYNCPUBLICATIONDEFAULTS consolidated view
  The SYSSYNCPUBLICATIONDEFAULTS view provides the default synchronization settings associated with publications involved in synchronization.
• SYSSYNCS consolidated view
  The SYSSYNCS view contains information relating to synchronization. Some columns in this view contain potentially sensitive data. For that reason, access to this view is restricted to users with DBA authority.
• SYSSYNCSCRIPT system view
  Each row in the SYSSYNCSCRIPT system view identifies a stored procedure for scripted upload. This view is almost identical to the SYSSYNCSCRIPTS view, except that the values in this view are in their raw format.
• SYSSYNCSCRIPTS consolidated view
  Each row in the SYSSYNCSCRIPTS view identifies a stored procedure for scripted upload. This view is almost identical to the SYSSYNCSCRIPT system view, except that the values are in human-readable format, as opposed to raw data.
• SYSSYNCSUBSCRIPTIONS consolidated view
  The SYSSYNCSUBSCRIPTIONS view contains the synchronization settings associated with synchronization subscriptions.
• SYSSYNCUSERS consolidated view
  A view of synchronization settings associated with synchronization users.
• SYSTAB system view
  Each row of the SYSTAB system view describes one table or view in the database. Additional information for views can be found in the SYSVIEW system view. The underlying system table for this view is ISYSTAB.
• SYSTABAUTH consolidated view
  The SYSTABAUTH view contains information from the SYSTABLEPERM system view, but in a more readable format.
• SYSTABCOL system view
  The SYSTABCOL system view contains one row for each column of each table and view in the database. The underlying system table for this view is ISYSTABCOL.
• SYSTABLE compatibility view (deprecated)
  The SYSTABLE view is provided for compatibility with older versions of the software that offered a SYSTABLE system table. However, the SYSTABLE system table has been replaced by the ISYSTAB system table, and its corresponding SYSTAB system view, which you should use instead.
• SYSTABLEPERM system view
  Permissions given by the GRANT statement are stored in the SYSTABLEPERM system view. Each row in this view corresponds to one table, one user ID granting the permission (grantor) and one user ID granted the permission (grantee). The underlying system table for this view is ISYSTABLEPERM.
• SYSTEXTCONFIG system view
  Each row in the SYSTEXTCONFIG system view describes one text configuration object, for use with the full text search feature. The underlying system table for this view is ISYSTEXTCONFIG.
• SYSTEXTIDX system view
  Each row in the SYSTEXTIDX system view describes one text index. The underlying system table for this view is ISYSTEXTIDX.
• SYSTEXTIDXTAB system view
  Each row in the SYSTEXTIDXTAB system view describes a generated table that is part of a text index. The underlying system table for this view is ISYSTEXTIDXTAB.
• SYSTRIGGER system view
  Each row in the SYSTRIGGER system view describes one trigger in the database. This view also contains triggers that are automatically created for foreign key definitions which have a referential triggered action (such as ON DELETE CASCADE). The underlying system table for this view is ISYSTRIGGER.
• SYSTRIGGERS consolidated view
  Each row in the SYSTRIGGERS view describes one trigger in the database. This view also contains triggers that are automatically created for foreign key definitions which have a referential triggered action (such as ON DELETE CASCADE).
• SYSTYPEMAP system view
  The SYSTYPEMAP system view contains the compatibility mapping values for entries in the SYSSQLSERVERTYPE system view. The underlying system table for this view is ISYSTYPEMAP.
• SYSTYPES ASE Compatibility View
  systypes contains one row for each system-supplied and user-defined datatype. Domains (defined by rules) and defaults are given, if they exist.
• SYSUSER system view
  Each row in the SYSUSER system view describes a user in the system. The underlying system table for this view is ISYSUSER.
• SYSUSERAUTH compatibility view (deprecated)
  The SYSUSERAUTH view is provided for compatibility with older versions of the software. Use the SYSUSERAUTHORITY system view instead.
• SYSUSERAUTHORITY system view
  Each row of SYSUSERAUTHORITY system view describes an authority granted to one user ID. The underlying system table for this view is ISYSUSERAUTHORITY.
• SYSUSERLIST compatibility view (deprecated)
  The SYSUSERAUTH view is provided for compatibility with older versions of the software.
• SYSUSERMESSAGE system view
  Each row in the SYSUSERMESSAGE system view holds a user-defined message for an error condition. The underlying system table for this view is ISYSUSERMESSAGE.
• SYSUSEROPTIONS consolidated view
  The SYSUSEROPTIONS view contains the option settings that are in effect for each user. If a user has no setting for an option, this view displays the public setting for the option.
• SYSUSERPERM compatibility view (deprecated)
  This view is deprecated because it only shows the authorities and permissions available in previous versions. You should change your application to use the SYSUSERAUTHORITY system view instead.
• SYSUSERPERMS compatibility view (deprecated)
  This view is deprecated because it only shows the authorities and permissions available in previous versions. You should change your application to use the SYSUSERAUTHORITY and SYSUSER system views instead.
• SYSUSERTYPE system view
  Each row in the SYSUSERTYPE system view holds a description of a user-defined data type. The underlying system table for this view is ISYSUSERTYPE.
• SYSUSERS ASE Compatibility View
  sysusers contains one row for each user allowed in the database, and one row for each group or roles.
• SYSVIEW System View
  Each row in the SYSVIEW system view describes a view in the database.
• SYSVIEWS consolidated view
  Each row of the SYSVIEWS view describes one view, including its view definition.
• SYSWEBSERVICE system view
  Each row in the SYSWEBSERVICE system view holds a description of a web service. The underlying system table for this view is ISYSWEBSERVICE.
• Transact-SQL Compatibility Views
  Adaptive Server Enterprise and Sybase IQ have different system catalogs, reflecting the different uses for the two products.