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, schemas contain validation expressions and validation messages.

Use the Schema options to add, update, or delete table, field, index, or sequence definitions. The following table lists the Schema menu options and gives a brief description of each. The sections following the table contain detailed descriptions of these schemas.

Table 1. Schema menu
Schema Description
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
Adjust Field Width... Alters field width value in a table