Informix Guide to SQL: Reference
Chapter 1: System Catalog
Home
Contents
Index
Master Index
New Book
Objects Tracked by the System Catalog Tables
The system catalog tables track the following objects:
Tables and constraints
Views
Triggers
Data types
Authorized users and privileges that are associated with every table that you create
Casts
Routines
Access methods and operator classes
Error, warning, and informational messages associated with user-defined routines
Inheritance relationships
Universal Server generates system catalog tables automatically when you create a database, and you can query them as you would query any other table in the database. The data for a newly created database and the system catalog tables for that database reside in the same dbspace.
Informix Guide to SQL: Reference
, version 9.1
Copyright © 1998, Informix Software, Inc. All rights reserved.