Model Database Tables

Creating new database Tables in your model through the Database Builder is very simple.

Access     Tools | Database Builder | Right-click on Tables Package | Add new Table

A database Table element is immediately added to the Package.

To define the  database Table, right-click on it and select Properties. The Table Properties dialog displays, on which you define the characteristics of the Table such as:

·The Table name
·Notes on, or a description of, the Table
·The Table's Status, Complexity, Version and Phase
·The Table Owner (and, if necessary, an alternative Tablespace Table storage for DBMSs such as Oracle and DB2)
·Tagged Values to define properties specific to MySQL or Oracle

You do not need to create Table columns through the Table Properties dialog, as you can do this quickly and easily through the Database Builder.

To delete a database Table, right-click on the Table name and click on the Delete <tablename> option. A prompt displays to confirm deletion of the Table and its contents; click on the Yes button.


·If you create a database Table element external to the Database Builder, in any part of the model other than the Tables Package, that Table element is automatically reassigned to the Tables Package


Learn more