View Designer

The View Designer is a powerful tool for creating and editing database views. To design a new view double-click the Create view in design view item within the Profile Window | Views page. To design the existing view select its name within the Profile Window | Views page and click the Design button on the toolbar or in the popup menu.

Note that views are available only in MySQL v5.0.1 or higher.

The View Designer window is divided into several tabs. The Designer tab is provided for adding tables to the view and selecting the columns, included into the view. The Options tab allows you to define various view properties. The Conditions tab allows you to define the criteria for data selection. The Columns tab contains various properties of the selected query columns: captions, grouping and sorting.

Please refer to topics to Designing Query Structure, Designing Query Conditions, Designing Query Values, and Designing Query Columns respectively for details.

Besides view graphical representation, View Designer also provides you with the SQL View of the view. This view is accessible through the SQL View button and displays the SQL statement, generated by the designer, or edited manually by user. You can use this mode to view the view SQL before its execution, or to create complicate views, which can't be designed by the standard means of View Designer.

All changes made to the view design takes effect only after the Apply button is pressed. If you want to discard all changes and revert to the last saved view design, click Revert.