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
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.
SYSCOLAUTH consolidated view
Each row in the SYSCOLAUTH view describes the set of privileges (UPDATE, SELECT, or REFERENCES) granted on a column.
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.
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.
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.
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.
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.
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.