Skip navigation links
MySQL Workbench :: 7 Data Modeling :: 7.5 Working with Models :: 7.5.3 Creating Views :: 7.5.3.1 Adding Views to the Physical Schemata
7.5.3.2 Adding Views to an EER Diagram »
Section Navigation      [Toggle]

7.5.3.1. Adding Views to the Physical Schemata

Double clicking the Add View icon in the Physical Schemata section of the MySQL Model page adds a view with the default name of 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. Using the view editor is described in Section 7.5.3.3, “The View Editor”.

Right clicking a table opens a pop-up menu with the following options:

  • Cut 'view_name'

  • Copy 'view_name'

  • Edit View...

  • Edit in New Window

  • Delete 'view_name'

If the table editor is not open the Edit View ... option 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 options are useful for copying views between different schemata and Copy SQL to Clipboard copies the CREATE VIEW statement to the clipboard.

Warning

Use the Delete 'view_name' to remove a view from the database. There will be no confirmation dialog box.

Any views added to the Physical Schemata also show up in the Catalog palette on the right side of the application. They may be added to an EER Digram by dragging and dropping them from this palette.