MySQL Workbench
Double-clicking the Physical Schemas section of the
Model Overview tab adds a table with the
default name of table1
. If a table with this
name already exists, the new table is named
table2
.
Adding a new table automatically opens the table editor docked at the bottom of the application. For information about using the table editor, see Section 8.1.10, “MySQL Table Editor”.
Right-clicking a table opens a context menu with the following items:
: Cut a table to optionally paste it into another schema.
: Copy a table to optionally paste it into another schema.
: Paste a cut or copied table. The Paste option is also accessible from the main menu.
: Changes the docked table editor to the selected table.
: Opens the table in a new table editor tab.
CREATE TABLE
statement for the table.
: Copies a comma-separated list of column names.
INSERT
statements based on the
model's inserts. Nothing is copied to the clipboard if the
table has no inserts defined.
INSERT
statement that is based on the model.
: Remove a table from the database.
This immediately deletes the table without a confirmation dialog box.
: If applicable, remove the figure associated with the table.
If the table editor is not open, the
item opens it. If it is already open, the selected table replaces the previous one. opens an additional table editor tab.
Any tables added to the Physical Schemas
section also show up in the Catalog Tree
palette within the EER Diagram tab. They may
be added to an EER Diagram by dragging and dropping them from this
palette.