Progress
SQL-89
Guide and Reference


Progress Metaschema Tables

This chapter describes the metaschema tables that Progress/SQL-89 uses. The metaschema tables are hidden database tables that hold the definitions of database objects such as tables, fields, indexes, and views. The information includes indication of table ownership, privileges, indexes, and the status of various flags. When SQL-89 data definition statements are processed, syntax is generated to create the appropriate schema records and to give values to certain schema fields.

The schema records created for SQL-89 tables have the same format as the schema records that Progress uses. However, some fields in the _File and _Field schema tables are not used with SQL-89-created tables. Views, however, have their own associated schema tables: _View, _View-Col, and _View-Ref.

Schema table names all begin with an underscore (_). All fields within the schema tables also begin with an underscore.

Schema table privilege fields (such as _Can-create) contain a pound sign (#) in front of the user name if the user has that privilege, but cannot grant it to or revoke it from other users. In all other respects, the form of the privilege fields is the same as in Progress.

You can update certain schema fields in the Progress Data Dictionary even if you create them with the SQL-89 CREATE TABLE statement. These include the description and help fields and other fields SQL-89 does not use. The Data Dictionary screens are automatically adjusted for SQL-89 tables to indicate which schema fields you can update using the Data Dictionary.


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095