MySQL Workbench Release Notes
To add a view, double-clicking the Add View
icon in the Physical Schemata section of the
MySQL Model page. The default name of the view
is view1. If a view with this name already
exists, the new view is named view2.
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 9.1.5.3, “The View Editor”.
Right-clicking a view opens a pop-up menu with the following items:
-
The '
view_name' is only cut from the EER canvas, and not removed from the schema. : deletes from both the EER canvas and schema.
: deletes from the EER canvas, but not the schema.
If the table editor is not open, the item opens it. If it is already open, the selected table replaces the previous one. opens a new view editor tab.
The cut and copy items are useful for copying views between
different schemata. copies the CREATE VIEW
statement to the clipboard.
Warning
Use the item to remove a view from the database. There will be no confirmation dialog box.
Any views added to the Physical Schemata
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.
In the EER Diagram right click the view and select 'Copy SQL to clipboard'.
In the schema view click the 'Create a new SQL tab for executed queries.' and past the clipboard
Execute the query with Ctrl+Enter