[+/-]
You can invoke the view editor by double clicking a view object on
the EER Diagram canvas or by double clicking a view in the
Physical Schemata
section on the MySQL
Model
page. Doing this opens the view editor docked at
the bottom of the application. Double clicking the title bar
undocks the editor. Do the same to redock it. Any number of views
may be open at the same time. Each additional view appears as a
tab at the top of the view editor,
There are two tabs at the bottom of the view editor, the View and the Privileges tabs. Navigate between different tabs using the mouse or from the keyboard by pressing Ctrl + Alt + Tab.
From the View
tab of the view editor you can
perform the following tasks:
Rename the view using the Name text box.
Enter the SQL to create a view using the SQL text area.
Comment a view using the Comments text area.
The Privileges
tab of the view editor
functions in exactly the same way as the
Privileges
tab of the table editor. For more
information, see
Section 7.5.1.3.10, “The Privileges Tab”.
When you select a view on the EER Diagram canvas, its properties
are displayed in the Properties
palette. Most
of the properties accessible from the
Properties
palette apply to the appearance of
a view on the EER Diagram canvas.
For a list of the properties accessible through the
Properties
palette see
Section 7.3.9, “The Properties Palette”.