To view detailed system
information views and definitions (Sybase Central):
Connect to the database as a user with DBA authority.
Right-click the database and choose Configure Owner/Container Filtering.
Click SYS and then click OK.
In the left pane, double-click Views.
In the left pane, click a view, and in the right pane, click the SQL tab.
Click the Data tab to view detailed information about the selected view.
The following table lists system views. For syntax, see Chapter 8, “System Views,” of Reference: Building Blocks, Tables, and Procedures
System View name |
|---|
SYSCOLUMNS system view |
SYSFKEY system view |
SYSIQBACKUPHISTORY system view |
SYSIQBACKUPHISTORYDETAIL system view |
SYSIQDBFILE system view |
SYSIQDBSPACE system view |
SYSIQIDX system view |
SYSIQINFO system view |
SYSIQJOINIDX system view |
SYSIQJOINIXCOLUMN system view |
SYSIQJOINIXTABLE system view |
SYSIQPARTITIONCOLUMN system view |
SYSIQTAB system view |
SYSLOGINPOLICY system view |
SYSLOGINPOLICYOPTION system view |
SYSPARTITION system view |
SYSPARTITIONKEY system view |
SYSPARTITIONSCHEME system view |
SYSSSYNCPROFILE system view |
SYSUSER system view |
Additional system views are common to both Sybase IQ and SQL Anywhere.
See ”System views”in SQL Anywhere Server - SQL Reference.
For deprecated system views, see “Deprecated features”. These views are visible in the product, but replaced by other views and therefore no longer documented.
