Appendix A: Extended Attribute System Tables  The extended attribute system tables

Appendix A: Extended Attribute System Tables

About the extended attribute system tables

When you provide application-based information such as the text to use for labels and headings for the columns, validation rules, display formats, and edit styles for a database table, PocketBuilder stores this information in system tables in your database. These system tables are called the extended attribute system tables. The tables contain all the information related to the extended attributes for the tables and columns in the database. The extended attributes are used in DataWindow objects.

The system tables

There are five extended attribute system tables.

Table A-1: List of extended attribute system tables

Table

Contains information about

PBCatTbl

Tables in the database

PBCatCol

Columns in the database

PBCatFmt

Display formats

PBCatVld

Validation rules

PBCatEdt

Edit styles

What to do with the tables

You can open and look at these tables just like other tables, in the Database painter. You might want to create a report of the extended attribute information used in your database by building a DataWindow object whose data source is the extended attribute system tables.

NoteCaution You should not change the values in the extended attribute system tables. PocketBuilder maintains this information automatically whenever you change information for a table or column in the Database painter.





Copyright © 2004. Sybase Inc. All rights reserved. The extended attribute system tables

View this book as PDF