Table Editor

The Table Editor dialog is intended for editing the following properties of a diagram table: general and database-specific table options (table name, type, etc.); table columns, table indexes, display options, and other ones.

To open the Table Editor, simply double-click a table on the diagram or select the Properties item from the table context menu.

Table Editor consist of several tabs, each of which is described in details below.

General

This tab allows you to tune the basic table properties, which are used for generating CREATE TABLE or ALTER TABLE statements for executing on the MySQL server.

Table name

The name of the table must be unique within the database. To check your diagram for the uniqueness of table names use the Check Diagram tool.

Table type

MySQL-specific type of the edited table. This type defines how MySQL stores and searches data in tables. Note, that to use MySQL foreign keys (diagram references) you should use the InnoDB table type.

Row format

This option defines how rows will be stored in the MySQL table.

Temporary

This options allows you to create a temporary table, i.e. a table which drops itself at the end of the session.

Checksum

This option works for MyISAM tables only. It maintains a checksum for all rows (makes table a little slower to update but makes it easier to find the corrupted tables).

Pack keys

This option works for MyISAM and ISAM tables only. It makes table indexes smaller. This usually makes updates slower and reads faster.

Delay key write

This option works for MyISAM tables only. It delays key table updates until the table is closed.

Min. rows

This option defines minimum number of rows you plan to store in the table. Leave zero for the default value.

Max. rows

This option defines maximum number of rows you plan to store in the table. Leave zero for the default value.

Character Set

This option specifies the table character set.

Collate

This option specifies the table collation.

Comment

A comment for your table.

Generate Table

Set this option off to exclude the table from the default selection of generated tables in the Database Generation and

Database Modification tools.

Columns

Use the Columns tab for adding, modifying, and deleting table columns. Please see the topic Column Editor for the detailed information.

Indexes

The Indexes tab is intended for managing table indexes. Please see the Index Editor topic for the detailed information.

Triggers

The Triggers tab is intended for managing table triggers. Please see the Trigger Editor topic for the detailed information.

Script

This tab allows you to set SQL statements, which will be executed before (use Begin tab) and after (use End tab) generation of the table.

Preview

The Preview tab displays the SQL statement, which will be executed during the database generation. This statement is made up according to the changes you have made using previous tabs. Note, that the text within the editor is read-only.

Note

The Note tab allows you to define a description and an annotation for the edited table. This properties will not affect the physical MySQL database, but they can be useful for your diagram development.

Format

These options allow you to set table line and fill color for displaying on the diagram, different from the default table colors, which are defined within the Diagram Display Preferences dialog.

Database Generation: Database Generation

Diagram: Diagram Display Preferences