|
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 tables, in order to satisfy a commonly needed join.
To ensure compatibility with future versions of the SQL Anywhere catalogue, make sure your applications make use of system views and not the underlying system tables, which may change.
Detailed information about system views, including the view definition, is available in Sybase Central:
To view system views, right-click a connected database, choose Filter Objects by Owner, and select SYS. Open the Views folder for the database.
You can see the view definition by selecting the view in the left pane and then clicking the SQL tab in the right pane.
To display the data, open the View folder in the left pane and select a view. In the right pane, click the Data tab.
SYSARTICLE system view
SYSARTICLECOL system view
SYSCAPABILITY system view
SYSCAPABILITYNAME system view
SYSCHECK system view
SYSCOLPERM system view
SYSCOLSTAT system view
SYSCONSTRAINT system view
SYSDEPENDENCY system view
SYSDOMAIN system view
SYSEVENT system view
SYSEVENTTYPE system view
SYSEXTERNLOGIN system view
SYSFILE 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
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
SYSTRIGGER system view
SYSTYPEMAP system view
SYSUSER system view
SYSUSERAUTHORITY system view
SYSUSERMESSAGE system view
SYSUSERTYPE system view
SYSVIEW system view
SYSWEBSERVICE system view