The structure of a relational database is stored in the data dictionary tables of the database.
The following table describes the product data dictionary tables.
| Table name | Contents |
|---|---|
| MAXOBJECT | All objects. Links an object to its table or view. |
| MAXTABLE | All tables. |
| MAXVIEW | All views. |
| MAXATTRIBUTE | All attributes of an object. A table or view attribute depends on the attributes of the object. |
| MAXVIEWCOLUMN | All view columns. |
| MAXRELATIONSHIP | All relationships defined on objects. |
| MAXSEQUENCE | All sequences used in the system. In SQL Server, the sequences are generated from this table. Oracle and DB2® use database sequence generators. |
| MAXSYSINDEXES | All indexes in the system. This table contains the index name, uniqueness and storage partition that is used in the MAXSYSKEYS table. |
| MAXSYSKEYS | The columns in an index. |