System views

The catalog contains system tables that link together by keys and indexes. In SQL Anywhere, the system tables are hidden. However, there is a system view for each table. In some cases, a system view may also include columns from more than one system table, to satisfy a commonly needed join.

To ensure compatibility with future versions of the SQL Anywhere catalog, make sure your applications make use of system views and not the underlying system tables, which may change.

To view detailed system information views and definitions (Sybase Central)
  1. Connect to the database as a user with DBA authority.

  2. Right-click the database and choose Configure Filter Owner.

  3. Click SYS and then click OK.

  4. In the left pane, double-click Views.

  5. In the left pane click a view, and in the right pane click the SQL tab.

    Click the Data tab to view details about the selected view.


SYSARTICLE system view
SYSARTICLECOL system view
SYSCAPABILITY system view
SYSCAPABILITYNAME system view
SYSCHECK system view
SYSCOLPERM system view
SYSCOLSTAT system view
SYSCONSTRAINT system view
SYSDBFILE system view
SYSDBSPACE system view
SYSDBSPACEPERM system view
SYSDEPENDENCY system view
SYSDOMAIN system view
SYSEVENT system view
SYSEVENTTYPE system view
SYSEXTERNENV system view
SYSEXTERNENVOBJECT system view
SYSEXTERNLOGIN system view
SYSFKEY system view
SYSGROUP system view
SYSHISTORY system view
SYSIDX system view
SYSIDXCOL system view
SYSJAR system view
SYSJARCOMPONENT system view
SYSJAVACLASS system view
SYSLOGINMAP system view
SYSLOGINPOLICY system view
SYSLOGINPOLICYOPTION system view
SYSMVOPTION system view
SYSMVOPTIONNAME system view
SYSOBJECT system view
SYSOPTION system view
SYSOPTSTAT system view
SYSPHYSIDX system view
SYSPROCEDURE system view
SYSPROCPARM system view
SYSPROCPERM system view
SYSPROXYTAB system view
SYSPUBLICATION system view
SYSREMARK system view
SYSREMOTEOPTION system view
SYSREMOTEOPTIONTYPE system view
SYSREMOTETYPE system view
SYSREMOTEUSER system view
SYSSCHEDULE system view
SYSSERVER system view
SYSSOURCE system view
SYSSQLSERVERTYPE system view
SYSSUBSCRIPTION system view
SYSSYNC system view
SYSSYNCSCRIPT system view
SYSTAB system view
SYSTABCOL system view
SYSTABLEPERM system view
SYSTEXTCONFIG system view
SYSTEXTIDX system view
SYSTEXTIDXTAB system view
SYSTRIGGER system view
SYSTYPEMAP system view
SYSUSER system view
SYSUSERAUTHORITY system view
SYSUSERMESSAGE system view
SYSUSERTYPE system view
SYSVIEW system view
SYSWEBSERVICE system view