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

Consolidated views

Consolidated views provide data in a form more frequently required by users.

For example, consolidated views often provide commonly needed joins. Consolidated views differ from system views in that they are not just a straight forward view of raw data in a underlying system table(s). For example, many of the columns in the system views are unintelligible ID values, whereas in the consolidated views, they are readable names.

In SQL Anywhere, the system owner (user SYS) owns the consolidated views.


In this section:
    ST_GEOMETRY_COLUMNS consolidated view
    Each row of the ST_GEOMETRY_COLUMNS system view describes a spatial column defined in the database.
    ST_SPATIAL_REFERENCE_SYSTEMS consolidated view
    Each row of the ST_SPATIAL_REFERENCE_SYSTEMS system view describes an SRS defined in the database. This view offers a slightly different amount of information than the SYSSPATIALREFERENCESYSTEM system view.
    ST_UNITS_OF_MEASURE consolidated view
    Each row of the ST_UNITS_OF_MEASURE system view describes a unit of measure defined in the database. This view offers more information than the SYSUNITOFMEASURE system view.
    SYSARTICLECOLS consolidated view
    Each row in the SYSARTICLECOLS 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 specifies the status of a capability for a remote database server. This view gets its data from the ISYSCAPABILITY system table.
    SYSCATALOG consolidated view
    Each row in the SYSCATALOG view describes a system table.
    SYSCOLAUTH consolidated view
    Each row in the SYSCOLAUTH view describes the set of privileges (UPDATE, SELECT, or REFERENCES) granted on a column.
    SYSCOLSTATS consolidated view
    The SYSCOLSTATS view contains the column statistics that are stored as histograms and used by the optimizer.
    SYSCOLUMNS consolidated view
    Each row in the SYSCOLUMNS view describes one column of each table and view in the catalog.
    SYSFOREIGNKEYS consolidated view
    Each row in the SYSFOREIGNKEYS view describes one foreign key for each table in the catalog.
    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.
    SYSOPTIONS consolidated view
    Each row in the SYSOPTIONS view describes one option created using the SET command. Each user can have their own setting for each option. In addition, settings for the PUBLIC user define the default settings to be used for users that do not have their own setting.
    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.
    SYSPROCPARMS consolidated view
    Each row in the SYSPROCPARMS view describes a parameter to a procedure in the database.
    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.
    SYSPUBLICATIONS consolidated view
    Each row in the SYSPUBLICATIONS view describes a publication.
    SYSREMOTEOPTION2 consolidated view
    Joins together, and presents in a more readable format, the columns from SYSREMOTEOPTION and SYSREMOTEOPTIONTYPE system views.
    SYSREMOTEOPTIONS consolidated view
    Each row of the SYSREMOTEOPTIONS view describes the values of a message link parameter.
    SYSREMOTETYPES consolidated view
    Each row of the SYSREMOTETYPES view describes one remote message type, including the publisher address.
    SYSREMOTEUSERS consolidated view
    Each row of the SYSREMOTEUSERS view describes a user ID with the REMOTE system privilege (a subscriber), together with the status of messages that were sent to and from that user.
    SYSROLEGRANTS consolidated view
    The SYSROLEGRANTS system view stores information about role membership and type of membership, just like the SYSROLEGRANT system view does. However, SYSROLEGRANTS includes role names and grantee names (not just IDs). The underlying system tables for this view are ISYSROLEGRANT and ISYSUSER.
    SYSSUBSCRIPTIONS consolidated view
    Each row describes a subscription from one user ID (which must have the REMOTE system privilege) to one publication.
    SYSSYNC2 consolidated view
    The SYSSYNC2 view provides public access to the data found in the SYSSYNC system view (information related to synchronization) without exposing potentially sensitive data.
    SYSSYNCPUBLICATIONDEFAULTS consolidated view
    The SYSSYNCPUBLICATIONDEFAULTS view provides the default synchronization settings associated with publications involved in synchronization.
    SYSSYNCS consolidated view
    The SYSSYNCS view contains information relating to synchronization.
    SYSSYNCSCRIPTS consolidated view
    Each row in the SYSSYNCSCRIPTS view identifies a stored procedure for scripted upload. This view is almost identical to the SYSSYNCSCRIPT system view, except that the values are in human-readable format, as opposed to raw data.
    SYSSYNCSUBSCRIPTIONS consolidated view
    The SYSSYNCSUBSCRIPTIONS view contains the synchronization settings associated with synchronization subscriptions.
    SYSSYNCUSERS consolidated view
    A view of synchronization settings associated with synchronization users.
    SYSTABAUTH consolidated view
    The SYSTABAUTH view contains information from the SYSTABLEPERM system view, but in a more readable format.
    SYSTRIGGERS consolidated view
    Each row in the SYSTRIGGERS view describes one trigger in the database. This view also contains triggers that are automatically created for foreign key definitions which have a referential triggered action (such as ON DELETE CASCADE).
    SYSUSEROPTIONS consolidated view
    The SYSUSEROPTIONS view contains the option settings that are in effect for each user. If a user has no setting for an option, this view displays the public setting for the option.
    SYSVIEWS consolidated view
    Each row of the SYSVIEWS view describes one view, including its view definition.