7.7.1.1. Adding Tables to the Physical Schemata

7.7.1.1. Adding Tables to the Physical Schemata
Prev	7.7.1. Creating Tables	Next

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 7.7.1.3, “The MySQL Table Editor”.

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

Cut 'table_name'
Copy 'table_name'
Edit Table...
Edit in New Window...
Copy SQL to Clipboard
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'

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 Window... opens a new table editor tab.

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

Warning

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

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.