Two kinds of system tables exist in the database:
System tables provided by your DBMS
For information about the ASA system tables, see the chapter on system tables in the Adaptive Server Anywhere SQL Reference Manual in the online books for SQL Anywhere Studio.
PocketBuilder extended attribute system tables
PocketBuilder stores extended attribute information you provide when you create or modify a table (such as the text to use for labels and headings for the columns, validation rules, display formats, and edit styles) in system tables. These system tables contain information about database tables and columns. Extended attribute information extends database definitions. Table 16-6 lists the extended attribute system tables.
In the Employee table, for example, one
column name is Emp_lname. A label and
a heading for the column are defined for PocketBuilder to use in DataWindow
objects. The column label is defined as Last
Name:. The column heading is defined as Last
Name. The label and heading are stored in the PBCatCol table
in the extended attribute system tables.
The extended attribute system tables are maintained by PocketBuilder. Only PocketBuilder users can enter information into the extended attribute system tables. For more information, see Appendix A, “Extended Attribute System Tables.”
You can open system tables in the Database painter, just like other tables.
By default, PocketBuilder shows only user-created tables in the Objects view. If you highlight Tables and select Show System Tables from the pop-up menu, PocketBuilder also shows system tables.
| Copyright © 2004. Sybase Inc. All rights reserved. |
|
|
