To invoke the view editor, double-click a view object on the EER Diagram canvas or double-click a view in thePhysical Schemas section on theMySQL Model 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 editor.
There are three tabs at the bottom of the view editor:View,Comments, andPrivileges. Navigate between different tabs using the mouse or from the keyboard by pressingControl+Alt+Tab.
The View Tab
Use theView tab to perform the following tasks:
Rename the view using theName text box.
Enter the SQL to create a view using theSQL field.
Comment a view using theComments text area.
The Comments Tab
This tab enables you to enter comments for a particular view.
The Privileges Tab
ThePrivileges tab of the view editor functions in exactly the same way as thePrivileges tab of the routine editor. For more information, seeSection 9.1.6.1.2.2, “The Privileges Tab”.