DataWindow Designer stores five types of extended attribute information in the system tables as described in Table 11-1.
System table |
Information about |
Attributes |
|---|---|---|
pbcatcol |
Columns |
Names, comments, headers, labels, case, initial value, and justification |
pbcatedt |
Edit styles |
Edit style names and definitions |
pbcatfmt |
Display formats |
Display format names and definitions |
pbcattbl |
Tables |
Name, owner, default fonts (for data, headings and labels), and comments |
pbcatvld |
Validation rules |
Validation rule names and definitions |
For more about the DataWindow Designer system tables, see the Appendix in the User’s Guide.
Prefixes in system table names
For some databases, DataWindow Designer precedes the name of the system table
with a default DBMS-specific prefix. For example, the names of DataWindow Designer system
tables have the prefix DBO in a SQL Server database (such as DBO.pbcatcol),
or SYSTEM in an Oracle database (such as SYSTEM.pbcatfmt).
The preceding table gives the base name of each system table without the DBMS-specific prefix.
