Displaying the PowerBuilder extended attribute system tables

PowerBuilder updates the extended attribute system tables automatically whenever you change the information for a table or column. The PowerBuilder extended attribute system tables are different from the system tables provided by your DBMS.

You can display and open PowerBuilder extended attribute system tables in the Database painter just like other tables.

To display the PowerBuilder extended attribute system tables:

In the Database painter, highlight Tables in the list of database objects for the active connection and select Show System Tables from the pop-up menu.

The sample displays Installed Database Interfaces in tree format. The entry for S Y C Sybase A S E is expanded to show the A S E entry with the Tables folder highlighted. A pop up menu shows the items New Table, Show System Tables, which has a checkmark, Table Security, Refresh, and Properties, which is grayed.

The PowerBuilder extended attribute system tables and DBMS system tables display in the tables list, as follows:

PowerBuilder system tables The five system tables are: pbcatcol, pbcatedt, pbcatfmt, pbcattbl, and pbcatvld.

DBMS system tables The system tables supplied by the DBMS usually have a DBMS-specific prefix (such as sys or dbo).

Display the contents of a PowerBuilder system table in the Object Layout, Object Details, and/or Columns views.

For instructions, see the Users Guide.

Do not edit the extended attribute system tables Do not change the values in the PowerBuilder extended attribute system tables.