PowerBuilder stores five types of extended attribute information in the system tables as described in Table 12-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 PowerBuilder system tables, see the Appendix in the Users Guide.
Prefixes in system table names
For some databases, PowerBuilder precedes the name of the system
table with a default DBMS-specific prefix. For example, the names
of PowerBuilder 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.
