Documentation Home
MySQL Workbench Manual
Related Documentation Download this Manual
PDF (US Ltr) - 16.3Mb
PDF (A4) - 16.3Mb
HTML Download (TGZ) - 14.6Mb
HTML Download (Zip) - 14.7Mb

MySQL Workbench Manual  /  ...  /  Adding Views to the Physical Schemas Adding Views to the Physical Schemas

To add a view, double-clicking the Add View icon in the Physical Schemas 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, “The View Editor”.

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

  • Cut 'view_name'

    The 'view_name' is only cut from the EER canvas, and not removed from the schema.

  • Copy 'view_name'

  • Paste

  • Edit View...

  • Edit in New Window...

  • Copy SQL to Clipboard

  • Delete 'view_name': deletes from both the EER canvas and schema.

  • Remove 'view_name': deletes from the EER canvas, but not the schema.

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 schemas. Copy SQL to Clipboard copies the CREATE VIEW 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 Physical Schemas 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.

User Comments
User comments in this section are, as the name implies, provided by MySQL users. The MySQL documentation team is not responsible for, nor do they endorse, any of the information provided here.
  Posted by John King on February 5, 2015
These steps don't create a view in the database. The following does.
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

Sign Up Login You must be logged in to post a comment.