Displaying the DataWindow Designer extended attribute system tables

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

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

To display the DataWindow Designer extended attribute system tables:

1. 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.

   

2. The DataWindow Designer extended attribute system tables and DBMS system tables display in the tables list, as follows:

   • DataWindow Designer 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).

     

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

   For instructions, see the User’s Guide.

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

---

Copyright © 2007. Sybase Inc. All rights reserved.

View this book as PDF