About system tables

Two kinds of system tables exist in the database:

About InfoMaker system tables

InfoMaker stores extended attribute information you provide when you create or modify a table (such as the text to use for labels and headings for the columns, validation rules, display formats, and edit styles) in system tables. These system tables contain information about database tables and columns. Extended attribute information extends database definitions.

In the Employee table, for example, one column name is Emp_lname. A label and a heading for the column are defined for InfoMaker to use in reports. The column label is defined as Last Name:. The column heading is defined as Last Name. The label and heading are stored in the PBCatCol table in the extended attribute system tables.

The extended attribute system tables are maintained by InfoMaker, and only InfoMaker users can enter information into them. Table 3-6 lists the extended attribute system tables. For more information, see Appendix B, “The Extended Attribute System Tables.”

Table 3-6: Extended attribute system tables

This system table

Stores this extended attribute information

PBCatCol

Column data such as name, header and label for reports and forms, and header and label positions

PBCatEdt

Edit style names and definitions

PBCatFmt

Display format names and definitions

PBCatTbl

Table data such as name, fonts, and comments

PBCatVld

Validation rule names and definitions

Opening and displaying system tables

You can open system tables like other tables, in the Database painter.

By default, InfoMaker shows only user-created tables in the Objects view. If you highlight Tables and select Show System Tables from the pop-up menu, InfoMaker also displays system tables.