Skip navigation links
MySQL Workbench :: 7 Data Modeling :: 7.5 Working with Models :: 7.5.1 Creating Tables :: 7.5.1.1 Adding Tables to the Physical Schemata
7.5.1.2 Adding Tables to an EER Diagram »
Section Navigation      [Toggle]

7.5.1.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. Using the table editor is described in Section 7.5.1.3, “The MySQL Table Editor”.

Right clicking a table opens a pop-up menu with the following options:

  • Cut 'table_name'

  • Copy 'table_name'

  • Edit Table

  • Edit in New Window

  • Copy SQL to Clipboard

  • Copy Insert to Clipboard

  • Delete 'table_name'

If the table editor is not open the Edit Table ... option opens it. If it is already open, the selected table replaces the previous one. Edit in New Window opens a new table editor tab.

The cut and copy options are useful for copying tables between different schemata.

Warning

Use the Delete 'table_name' to remove a table from the database. There will be no confirmation dialog box.

Any tables added to the Physical Schemata 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.