To invoke the view editor, double-click a view object on the EER
Diagram canvas or double-click a view in the
Schemata section on the
page. 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
There are three tabs at the bottom of the view editor: View, Comments, and Privileges. Navigate between different tabs using the mouse or from the keyboard by pressing Control+Alt+Tab.
The View Tab
Use the View tab to perform the following tasks:
Rename the view using the Name text box.
Enter the SQL to create a view using the SQL field.
Comment a view using the Comments text area.
The Comments Tab
This tab enables you to enter comments for a particular view.
The Privileges Tab
The Privileges tab of the view editor functions in exactly the same way as the Privileges tab of the routine editor. For more information, see Section 188.8.131.52.2.2, “The Privileges Tab”.