Progress
Language Tutorial
for Windows


Summary

The Data Dictionary is a tool that you use to create, view, and modify the properties of a database and database objects: tables, fields, indexes, and sequences. Database properties include those that define database objects and those that establish application defaults. Collectively, database properties are referred to as schema.

Databases have two names:

The Data Dictionary allows you to connect databases. When a database is connected, any Progress tool or application can access the data or schema of the database.

Table objects are defined with a unique name. The definitions of constituent fields and indexes make up the bulk of a table definition.

Field objects are defined with a unique name and by specifying a data type. Data types determine what kind of data a field can store:

Index objects are defined by specifying a name and the component fields. Other index properties define how the index works:

Sequences are objects that generate automatic incremental sequences. Using sequence properties, you can define three types of sequences:

Tables and fields have a validation property, which allow you to check criteria before allowing record deletions in a table or new values in a field. The validation property is made up of:

Databases have special events for which you can write triggers:

The database trigger property allows you to add default behaviors to a database, eliminating the need to code the behaviors in your procedures.

Field formats are symbols that tell Progress how you want to display data by default. Formats do not affect the actual data, just the display of the data.


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