Creating Database Tables and Referential Integrity Constraints from Business Components

The Create Database Objects Tool lets you create database tables based on the information in entity objects and associations, if specified, their database constraints as specified in the Entity Constraint Wizard. This is called forward generation. To access the tool, in the Workspace view of the Navigator, right-click a business components package and choose Create Database Objects.

WARNING: Be sure to archive existing data before creating new tables so that you can restore it if necessary. You will need to drop any existing database objects that have the same name as those used in the new database tables and key constraints. If there is data in an identically named existing table, it will be lost if you proceed. A message box will warn you of this beforehand.

Name

This field is not editable; it reminds you of the package you are using.

Database Object

This is a list of the entities in the current package. Each entity object has information about the database object it represents. This database information is used to determine the object to create.

Objects to Create

The selected objects that will be created when you click OK.

Note: For foreign keys to be created, both the source and destination entities involved in the association must be inserted into the Objects to Create list.

>

Click to move the selected Database Objects into the Objects to Create list.

<

Click to remove Entities from the Objects to Create list.