Progress
Basic Database
Tools


Schema Menu

The schema of the database is the definition of its structure: the tables it contains, the fields within the tables, sequences, etc. In addition to database structure, Progress database schemas contain validation expressions and validation messages.

Choose the Schema options to add, update, or delete table, field, index, or sequence definitions. Table 9–1 lists the Schema menu options and gives a brief description of each. More detailed descriptions of the options follow the table.

Table 9–1: Schema Menu 
Schema
Modify Table...
Changes information defined for an existing table.
Add New Table...
Creates a new table definition.
Delete Table(s)...
Removes one or more table definitions.
Field Editor...
Adds, alters, or removes fields from a table definition.
Reorder Fields...
Resequences the fields into alphabetical order, or resets the order numbers of the fields.
Global Field Name Change...
Changes a field name throughout the database.
Index Editor...
Adds, alters, or removes indexes in a table.
Sequence Editor...
Adds, alters, or removes sequences in a table.


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