System Catalog Tables

Sometimes called the "data dictionary," the system catalog tables describe the structure of the database. The database server automatically generates the system catalog tables when you create a database. Each system catalog table contains specific information about elements in the database.

System catalog tables track the following objects:

• Tables, views, sequences, and synonyms
• Constraints and indexes
• Triggers
• Authorized users and privileges
• User-defined routines
• Data types and casts
• Aggregates and modifiers
• Access methods and operator classes
• Inheritance relationships

For information about the system catalog, see the IBM Informix Guide to SQL: Reference.