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|