Contents of the extended attribute system tables
PowerBuilder stores five types of extended attribute information
in the system tables as described in the following table.
|
System table |
Information about |
Attributes |
|---|---|---|
|
pbcatcol |
Columns |
Names, comments, headers, labels, case, initial |
|
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 |
|
pbcatvld |
Validation rules |
Validation rule names and |
For more about the PowerBuilder system tables, see Appendix A, The Extended Attribute System Tables in 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.