To add a view, double-clicking the
icon in the
Physical Schemata section of the
MySQL Model page. The default name of the view
view1. If a view with this name already
exists, the new view is named
Adding a new view automatically opens the view editor docked at the bottom of the application. For information about using the view editor, see Section 184.108.40.206, “The View Editor”.
Right-clicking a view opens a pop-up menu with the following items:
As of MySQL Workbench 5.2.45, the
view_name' is only cut from the
EER canvas. Before, it was also removed from the schema.
Edit in New Window...
Copy SQL to Clipboard
from both the EER canvas and schema.
from the EER canvas, but not the schema.
This option exists as of MySQL Workbench 5.2.45.
If the table editor is not open, the Edit View... item opens it. If it is already open, the selected table replaces the previous one. Edit in New Window... opens a new view editor tab.
The cut and copy items are useful for copying views between
different schemata. Copy SQL to
Clipboard copies the
statement to the clipboard.
Use the Delete
view_name' item to
remove a view from the database. There will be
no confirmation dialog box.
Any views added to the
section also show up in the
Catalog palette on
the left side of the application. They may be added to an EER
Diagram, when in the EER Diagram tab, by dragging and dropping
them from this palette.