Chapter 11: System Views

About this chapter

This chapter lists predefined views for the Sybase IQ system tables.

The system tables use numbers to identify tables, user IDs, and so forth. Although this is efficient for internal use, it makes these tables difficult for people to interpret. A number of predefined system views are provided that present the information in the system tables in a more 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.