Documentation Home
MySQL Workbench Manual
Related Documentation Download this Manual
PDF (US Ltr) - 14.8Mb
PDF (A4) - 14.8Mb
EPUB - 12.9Mb
HTML Download (TGZ) - 12.9Mb
HTML Download (Zip) - 12.9Mb


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

9.1.3.1 Adding Tables to the Physical Schemata

Double-clicking the Add table icon in the Physical Schemata section of the MySQL Model page 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.11, “The 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...: Changes the docked table editor to the selected table.

  • Edit 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.

If the table editor is not open, the Edit Table... item opens it. If it is already open, the selected table replaces the previous one. Edit in New Tab... opens an additional table editor tab.

Any tables added to the Physical Schemata section also show up in the Catalog palette on the right side of the application. They may be added to an EER Diagram by dragging and dropping them from this palette.


User Comments
Sign Up Login You must be logged in to post a comment.