Creating Models › Creating a Physical Model › Tables › Table Editor › Define MySQL Table Properties

Define MySQL Table Properties

Use the MySQL Table Editor to define table properties. This procedure assumes you are working in a physical model, with MySQL defined as the target server.

To define properties for a MySQL table

1. Click Tables on the Model menu.

   The MySQL Table Editor opens.

2. Select the table in the Navigation Grid that you want to define and work with the following options:

   Note: Click New on the toolbar to create a new table. Use the Enter filter text box to filter a very large list of tables to quickly locate the one that you want to define.

   Physical Name

   Specifies the physical name of the table. Change the physical name of the table in this field.

   DB Owner

   Specifies the owner of the database to which the table belongs. Change the owner name of the table in this field.

   Physical Only

   Specifies whether the table is suppressed from a logical model and appears in a physical model only.

   Generate

   Generates SQL during forward engineering. Clear the check box if you do not want to generate SQL.

3. Click the Volumetrics tab and work with the following options:

   Initial Row Count

   Defines row count for the table. Enter a value in the field.

   Max Rows

   Defines row sizing for the table. Enter a value in the field.

   Growth By Month

   Defines growth increments for the table. Enter a value in the field.

4. Work with the other tabs in the editor to access additional design features, for example:
   • Specify validation rules in the Validation tab
   • Work with style sheets to format the font used in the display of the table in the Style tab
   • View where the table is used in the model in the Where Used tab
   • Specify the order of DDL generation in the Object Creation Order tab
5. (Optional) Click the Comment tab and enter any comments that you want to associate with the table.
6. (Optional) Click the UDP tab to work with user-defined properties for the table.
7. (Optional) Click the Notes tab to view history information and view or edit user notes.
8. Click Close.

   The table is defined and the MySQL Table Editor closes.