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.
© 2012, Oracle Corporation and/or its affiliates
