View Wizard

The View Wizard allows you to create database views in a fast and convenient way, guiding you step by step through the process of defining view structure, options, and criteria. To run the wizard double-click the Create new query by using wizard item within the Profile Window | Views page.

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

The first step of the View Wizard allows you to set the name of the new view (this name must be unique within the database).

The second step of the View Wizard allows you to select tables and columns to include into the view.

Select the table name from the Tables drop-down list and move table columns from the Available Fields list to the Selected Fields. Note, that you can select fields from multiple tables.

The next step of the wizard allows you to build conditions, which define the data selection criteria.

Please, examine the Designing Query Conditions for more details.

This step displays the list of view joins, based on the profile relationships. View joins are intended for linking the selected data between tables.

The buttons below the join list are intended for managing the list: adding new joins, editing joins through the Join Properties dialog, or deleting the joins.

With the next step of the wizard you can set additional view parameters.

To learn more about such query parameters, as limit, offset and others, please refer to the Designing Query Options topic.

The final step of the wizard allows you to select the action to perform after the creation and displays information about the creation errors, if such occur.

Select Open the view in design mode to open the View Designer after the view is created. To view the data of the new view within the Grid Data View, select Open the view for viewing data. To close the wizard without any action after creating the view, select the Take no action item.

To create the view with all the parameters you have set, click the Finish button.