Selecting Tables for Exclusion from the Schema

When you have established the connection to the external database, the Tables sheet of the External Schema Wizard, shown in the following image, then enables you to select the tables that are to be excluded from the external database schema transformation.

By default, all base tables and views are included. You can select a table for exclusion at any stage of the schema transformation, as long as it is not being referenced.

Tables are grouped by table type into base tables, views, and system tables. Bitmaps indicate each of the table types, and they are used throughout the External Schema Wizard. If a remark or description exists for a table or view in the external relational database, it is displayed at the right of the table or view name.

To select tables for exclusion from your external database schema

1. In the Table Name list box, click the check box at the left of each table or view that you want to exclude. The check box is then unchecked and that table is no longer included in your external database schema.

   When you access this sheet again, only those tables previously selected are checked. If one or more selected tables are subsequently unchecked, existing class definitions using that table are then marked as obsolete and are deleted.

2. Click the Next > button when you have selected the tables or views to exclude from your external database schema. Alternatively, click the Close button to close the wizard.

When you click the Next > button, the External Schema Wizard then enables you to select identifiers for class and property names.