System Tables
The database system contains a series of system tables with information about database objects and their connection to each other, statistics system tables, monitor system tables and loader system tables.
The following information describes how to evaluate the system tables.
When you specify
SELECT
statements for the system tables, you have to bear in mind some general information
To find out which system table contains information for a particular database term, consult the list of database terms.
To find out which information a particular system table can provide, see the examples of
SELECT
statements in the section on evaluating system tables. The examples make use of the demo data for the SQL Tutorial.
For a complete definition of some of the most important system tables, see Definition of the System Tables.