Alphabetical List of System Views

System tables are hidden; however, there is a system view for each table. To ensure compatibility with future versions of the IQ main store, make sure your applications use system views and not the underlying system tables, which may change.

• ASE T-SQL Compatibility Views
  SAP 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.
• SYSCERTIFICATE System View
  Each row of the SYSCERTIFICATE system view stores a certificate in text PEM-format. The underlying system table for this view is ISYSCERTIFICATE.
• 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 privileges to individual columns in a table. Each column with UPDATE, SELECT, or REFERENCES privileges 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 privilege 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 compatibility 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.
• SYSGROUPS compatibility 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.
• SYSIQLOGICALSERVER System View
  Presents a readable version of the ISYSIQLOGICALSERVER system table.
• SYSIQLOGINPOLICYLSINFO System View
  Presents a readable version of the table ISYSIQLOGINPOLICYLSINFO.
• SYSIQLSLOGINPOLICIES Consolidated View
  Describes all the logical server assignments from the login policies.
• SYSIQLSLOGINPOLICYOPTION System View
  Presents a version of the table ISYSIQLSLOGINPOLICYOPTION in a readable format.
• SYSIQLSMEMBER System View
  Presents group information from the ISYSIQLSMEMBER table, which stores logical server membership information.
• SYSIQLSMEMBERS Consolidated View
  Describes all user-defined logical server memberships.
• SYSIQLSPOLICY System View
  Presents a version of the table ISYSIQLSPOLICY in a readable format.
• SYSIQLSPOLICYOPTION System View
  Presents a version of the table ISYSIQLSPOLICYOPTION in a readable format.
• SYSIQMPXSERVER System View
  Presents a readable version of the table ISYSIQMPXSERVER. The ISYSIQMPXSERVER system table 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, 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.
• SYSIQRLVMERGEHISTORY System View
  A log entry is added for each row-level versioning (RLV) enabled-table each time a merge between the RLV store and the IQ main store begins. Log entries are updated when the merge is complete.
• SYSIQRVLOG System View
  Presents group information from ISYSIQRVLOG in a readable format. Each row in the SYSIQRVLOG view corresponds to a log for a RLV-enabled table .  The row with table_id 0 represents the server-wide commit log.
• 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.
• SYSLDAPSERVER System View
  Presents information on the ISYSLDAPSERVER system table in a readable format.
• 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. For that reason, access to this view is restricted. 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 role 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 who has been granted EXECUTE privilege on 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 message link parameter. The underlying system table for this view is ISYSREMOTEOPTION.
• SYSREMOTEOPTION2 consolidated view
  Joins together, and presents in a more readable format, the columns from SYSREMOTEOPTION and SYSREMOTEOPTIONTYPE system views.
• SYSREMOTEOPTIONS consolidated view
  Each row of the SYSREMOTEOPTIONS view describes the values of a message link parameter.
• 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 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 the REMOTE system privilege (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 the REMOTE system privilege (a subscriber), together with the status of messages that were sent to and from that user.
• SYSROLEGRANTEXT System View
  The SYSROLEGRANTEXT system view contains syntax extensions pertaining to the SET USER and CHANGE PASSWORD system privilege and is related to the SYSROLEGRANT system view.
• SYSROLEGRANT System View
  The SYSROLEGRANT system view contains one row for each grant of a system or user defined role. The underlying system table for this view is ISYSROLEGRANT.
• SYSROLEGRANTS System View
  The SYSROLEGRANTS system view is the same as the SYSROLEGRANT system view but includes two additional columns: the name of the role (not just the role ID) and the name of the grantee (not just user ID).
• 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. The underlying system table for this view is ISYSSCHEDULE.
• 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. SAP Sybase IQ 16.0 does not support subpartitioning.
• SYSSUBSCRIPTION system view
  Each row in the SYSSUBSCRIPTION system view describes a subscription from one user ID (which must have the REMOTE system privilege) 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 the REMOTE system privilege) 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. 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.
• 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
  Privileges granted on tables and views 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 privilege (grantor) and one user ID granted the privilege (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. Standalone roles are also stored in this view as well, but only the user_id, object_id, user_name, and user_type columns are meaningful for these roles. The underlying system table for this view is ISYSUSER.
• SYSUSERAUTH compatibility view (deprecated)
  Each row of the SYSUSERAUTH view describes a user, without exposing their user_id. Instead, each user is identified by their user name. Because this view displays passwords, you must have the SELECT ANY TABLE system privilege to view its data.
• SYSUSERAUTHORITY compatibility view (deprecated)
  The SYSUSERAUTHORITY view is provided for compatibility with older versions of the software. Use the SYSROLEGRANTS consolidated view instead.
• 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)
  Each row of the SYSUSERPERM view describes one user ID. You must have the SELECT ANY TABLE system privilege to view data in this view.
• 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 SYSROLEGRANTS consolidated view.
• 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 SAP Sybase IQ have different system catalogs, reflecting the different uses for the two products.