Tables
For creating, editing, deleting, and exporting database tables, the
following choices are available:
- Export Tables
- This option enables you to the following selective tasks on tables and
keys. An export uses the physical name of each element, including
tables, columns and keys.
- Export Selected Tables to Database
- Choose specific tables to export.
- Export Selected Tables with Keys to Database
- Choose specific keys to export.
- Drop Selected Tables to Database
- Choose specific tables to drop from the database.
- Drop Selected Keys to Database
- Choose specific keys to drop from the database.
- New Table
- This choice launches a Table Editor. Fill in the appropriate fields
to complete the table definition.

The Table Editor prompts your for the following
information:
- Name. This is a convenient logical name. Since
most databases have limitations on their physical names, this logical name is
a convenient way to provide a more descriptive name for the table.
- Physical Name. This is the physical name for the table
as the database will know it. Some databases have limitations on the
name length.
- Qualifier. Provide a qualifying name for the
table. This is a unique identifier for the table used in conjunction
with the table name to identify the table.
- Table columns. This is where you define the columns for
the table. To define a new column, click New.
- Primary key. Define the primary key for the table by
selecting a defined column name or names and clicking on the arrows.
You can also Edit, Copy, Delete, and
Rename tables.
- Generate DDL
- Generates the Data Definition Language for the table for later
uses.