Add table icon in the
Physical Schemata section of the
Model page adds a table with the default name of
table1. If a table with this name already
exists, the new table is named
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 22.214.171.124, “The MySQL Table Editor”.
Right-clicking a table opens a pop-up menu with the following items:
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
statement that is based on the model.
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.
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
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.
Copyright © 2006, 2014, Oracle and/or its affiliates. All rights reserved. Legal Notices