Documentation Home
MySQL Workbench Manual
Related Documentation Download this Manual
PDF (US Ltr) - 17.0Mb
PDF (A4) - 17.0Mb


MySQL Workbench Manual  /  ...  /  Adding Tables to the Physical Schemas

9.1.3.1 Adding Tables to the Physical Schemas

Double-clicking the Add table icon in 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 'table_name': Cut a table to optionally paste it into another schema.

  • Copy 'table_name': Copy a table to optionally paste it into another schema.

  • Paste 'table_name': Paste a cut or copied table. The Paste option is also accessible from the main Edit menu.

  • Edit 'table_name': Changes the docked table editor to the selected table.

  • Edit 'table_name' in New Tab: Opens the table in a new table editor tab.

  • Copy SQL to Clipboard: Copies a CREATE TABLE statement for the table.

  • Copy Column Names to Clipboard: Copies a comma-separated list of column names.

  • Copy Insert to Clipboard: Copies INSERT statements based on the model's inserts. Nothing is copied to the clipboard if the table has no inserts defined.

  • Copy Insert Template to Clipboard: Copies a generic INSERT statement that is based on the model.

  • Delete 'table_name': Remove a table from the database.

    Warning

    This immediately deletes the table without a confirmation dialog box.

  • Remove Figure 'table_name': If applicable, remove the figure associated with the table.

If the table editor is not open, the Edit 'table_name' item opens it. If it is already open, the selected table replaces the previous one. Edit 'table_name' in New Tab 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.