This chapter lists predefined views for Sybase IQ system tables.
The system tables are designed for internal use. To view the contents of the system tables, use the system views. A number of predefined system views are provided that present the information in the system tables in a readable format.
The definitions for the system views are included with their descriptions. Some of these definitions are complicated, but you do not need to understand them to use the views. They serve as good examples of what can be accomplished using the SELECT command and 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 straightforward view of raw data in an underlying system table. For example, many of the columns in the system views are unintelligible ID values, whereas in the consolidated views, they are readable names.
Consolidated views such as SYSCATALOG and SYSINDEXES are common to both Sybase IQ and SQL Anywhere. For definitions of these and other consolidated views, see "Consolidated views".
Compatibility views are deprecated views provided for compatibility with earlier versions of SQL Anywhere and Sybase IQ. Where possible, use system views and consolidated views instead of compatibility views, as support for compatibility views may be eliminated in future versions of Sybase IQ.
For detailed information on compatibility views, see "Compatability views".
Sybase IQ provides a set of views owned by the special user DBO, which correspond to the Adaptive Server Enterprise system tables and views. See “Transact-SQL compatibility views”.
