The Table Editor dialog window is intended for editing the following properties of a diagram table: general and database-specific table options (table name, etc.); table columns, table indexes, table triggers, table partitions, display options and others.
To open Table Editor, simply double-click on a table in the diagram or select the Properties item from the table context menu.
Table Editor consists of several tabs. Please see the detailed description below.
This tab allows you to adjust the basic table properties, which are used for generating CREATE TABLE or ALTER TABLE statements for executing on the MySQL server.
Delay key write
Use the Columns tab for adding, modifying, and deleting table columns. Please see the topic Column Editor for the detailed information.
The Indexes tab is intended for managing table indexes. Please see the Index Editor topic for the detailed information.
The Triggers tab is intended for managing table triggers. Please see the Trigger Editor topic for the detailed information.
The Partitions tab is intended for managing table partitions. Please see the Partition Editor topic for the detailed information.
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.
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.
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.
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. Please see the Formatting Table topic for the detailed information.