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 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 describes a capability. This view gets its data from the ISYSCAPABILITY and ISYSCAPABILITYNAME system tables.
• SYSCAPABILITY System View
  Each row of the SYSCAPABILITY system view identifies a capability of a remote server. The underlying system table for this view is ISYSCAPABILITY.
• SYSCAPABILITYNAME System View
  Each row in the SYSCAPABILITYNAME system view names a capability that is defined 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 through built-in functions and is not kept in the catalog.
• SYSCOLLATIONMAPPINGS Compatibility View (Deprecated)
  The SYSCOLLATIONMAPPINGS compatibility view contains only one row with the database collation mapping. It is obtainable though built-in functions and is not kept in the catalog.
• 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.
• SYSCOLSTAT System View
  The SYSCOLSTAT system view contains the column statistics, including histograms, that are used by the optimizer.
• 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 Sybase IQ that offered a SYSCOLUMN system table.
• 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
  Each row in the SYSEXTERNENV system view describes the information needed to identify and launch each of the external environments. The underlying system table for this view is ISYSEXTERNENV.
• SYSEXTERNENVOBJECT System View
  Each row in the SYSEXTERNENVOBJECT system view describes an installed external object. The underlying system table for this view is ISYSEXTERNENVOBJECT.
• 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.
• 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 Sybase IQ that offered a SYSFOREIGNKEY system table.
• SYSFOREIGNKEYS Consolidated View
  Each row in the SYSFOREIGNKEYS view describes one foreign key for each table in the catalog.
• SYSGROUP System View
  This view describes the many-to-many relationship between groups and members.
• SYSGROUPS Consolidated View
  This view describes the many-to-many relationship between groups and members.
• 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 Sybase IQ that offered a SYSINDEX system table.
• 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.
• 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 Sybase IQ that offered a SYSIXCOL system table.
• 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 SYSJARCOMPONENT 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 a Kerberos login.
• 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 user account.
• SYSMVOPTION System View
  Each row in the SYSMVOPTION system view describes the setting of one option value for a materialized view at the time of its creation.
• SYSMVOPTIONNAME System View
  Each row in the SYSMVOPTIONNAME system view contains the name of an option defined 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 one row for each option setting stored in the database.
• SYSOPTIONS Consolidated View
  Each row in the SYSOPTIONS view describes one option that was created using SET.
• SYSOPTSTAT System View
  The SYSOPTSTAT system view stores the cost model calibration information as computed by the ALTER DATABASE CALIBRATE statement.
• 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 is granted permission to execute a procedure.
• 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 SQL Remote or MobiLink publication. The underlying system table for this view is ISYSPUBLICATION.
• SYSPUBLICATIONS Consolidated View
  Each row in the SYSPUBLICATIONS view describes a SQL Remote or MobiLink 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 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 SQL Remote message link parameter.
• SYSREMOTEOPTIONTYPE System View
  Each row in the SYSREMOTEOPTIONTYPE system view describes one of the SQL Remote 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 SQL Remote 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 SQL Remote messages that were sent to and from that user.
• SYSREMOTEUSERS Consolidated View
  Each row of the SYSREMOTEUSERS view describes a user ID with REMOTE permissions (a subscriber), together with the status of SQL Remote 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.
• 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.3 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 MobiLink synchronization.
• SYSSYNC2 Consolidated View
  The SYSSYNC2 view provides public access to the data found in the SYSSYNC system view—information relating to MobiLink synchronization—without exposing potentially sensitive data.
• SYSSYNCPUBLICATIONDEFAULTS Consolidated View
  The SYSSYNCPUBLICATIONDEFAULTS view provides the default synchronization settings associated with publications involved in MobiLink synchronization.
• SYSSYNCS Consolidated View
  The SYSSYNCS view contains information relating to MobiLink synchronization.
• SYSSYNCSCRIPT System View
  Each row in the SYSSYNCSCRIPT system view identifies a stored procedure for MobiLink scripted upload.
• SYSSYNCSCRIPTS Consolidated View
  Each row in the SYSSYNCSCRIPTS view identifies a stored procedure for MobiLink scripted upload.
• SYSSYNCSUBSCRIPTIONS Consolidated View
  The SYSSYNCSUBSCRIPTIONS view contains the synchronization settings associated with MobiLink synchronization subscriptions.
• SYSSYNCUSERS Consolidated View
  A view of synchronization settings associated with MobiLink synchronization users.
• SYSTAB System View
  Each row of the SYSTAB system view describes one table or view in the database.
• SYSTABLE Compatibility View (Deprecated)
  The SYSTABLE view is provided for compatibility with older versions of Sybase IQ that offered a SYSTABLE system table.
• SYSTABAUTH Consolidated View
  The SYSTABAUTH view contains information from the SYSTABLEPERM system view, but in a 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.
• SYSTABLEPERM System View
  Permissions given by the GRANT statement are stored in the SYSTABLEPERM system view.
• 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.
• SYSTRIGGERS Consolidated View
  Each row in the SYSTRIGGERS view describes one trigger in the database.
• 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 Sybase IQ.
• 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 SYSUSERLIST view is provided for compatibility with older versions of Sybase IQ.
• SYSUSERMESSAGE System View
  Each row in the SYSUSERMESSAGE system view holds a user-defined message for an error condition.
• SYSUSEROPTIONS Consolidated View
  The SYSUSEROPTIONS view contains the option settings that are in effect for each user.
• SYSUSERPERM Compatibility View (Deprecated)
  This view is deprecated because it only shows the authorities and permissions available in previous versions.
• SYSUSERPERMS Compatibility View (Deprecated)
  This view is deprecated because it only shows the authorities and permissions available in previous versions.
• 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.
• Transact-SQL Compatibility Views
  Adaptive Server Enterprise and Sybase IQ have different system catalogs, reflecting the different uses for the two products.