Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.
SQL Anywhere 17 » SQL Anywhere Server - SQL Reference

Views

There are several types of views supported by the software.


In this section:
    System views
    The catalog contains system tables that link together by keys and indexes. The system tables are hidden. However, there is a system view for each table. A system view can also include columns from more than one system table to satisfy a commonly needed join.
    Consolidated views
    Consolidated views provide data in a form more frequently required by users.
    Compatibility views
    Compatibility views are views that are provided for compatibility with versions of the software that are 10 and earlier. Where possible use system and consolidated views instead, as support may diminish for some compatibility views in future releases.
    Views for Transact-SQL compatibility
    The Adaptive Server Enterprise and SQL Anywhere system catalogs are different.