Determine the following parameters on this page:
Select Database. In the drop-down list select a database, to which query is placed.
Physical Name. By default, table identifier is used as the physical name of the table.
Permit an Incorrect View to Be Created. The checkbox is deselected by default. Select the checkbox to create a view with an incorrect query.
Saved View. Select the checkbox to work both with view data and with data of a standard table. When the checkbox is selected, editing view data does not result in changing data of basic tables. When data of the basic tables is changed, view contents is not refreshed. Indexes can be created for a saved view.
NOTE. A view, which is saved incorrectly, cannot be created.
Query to Database. Create a query to database in the SQL language according to the syntax that is set for the selected DBMS driver.
The selected DBMS driver and the driver list are displayed next to the Query to Database field. By default, the driver list displays the selected driver used during repository connection setup. If query is specified for one or several drivers, the selected driver(s) will be marked in the driver list.
To show or hide the driver list, use the 
Hide Driver List/Show Driver List button.
Click the Check Query button to check if the created query is correct.
To set the specified query to database for all DBMS, click the Apply for All DBMS button. The confirmation dialog box opens. If query is specified for at least one driver that is different from the current one, all the specified queries will be replaced with the current one if the answer is positive.
Determine the following parameters on this page:
Database. Select the database in the drop-down list. The driver specified in settings of the selected database is set automatically on changing a database.
Physical Name. By default, table identifier is used as the physical name of the table.
Permit an Incorrect View to Be Created. The checkbox is deselected by default. Select it to permit creation of a view with an incorrect query.
Saved View. Selecting this checkbox enables the user to work both with view data and with data of a standard table. When the checkbox is selected, editing view data does not result in changing data of basic tables. When data of the basic tables is changed, view contents is not refreshed. Indexes can be created for a saved view.
NOTE. A view, which is saved incorrectly, cannot be created.
Driver. Select the driver type in the drop-down list. For details about available drivers see the Supported DBMS subsection. The Driver list displays by default the driver used in the selected database. If required, one can select another driver and determine the SQL query text for this driver. The parameter is relevant if the repository is used on servers with different DBMS, and settings in repository database are changed.
Query Text. Generate an SQL query in this box. The view will be built based on this query.
Apply to All DBMS. The button determines query text for all databases, that is, changing the driver does not affect query text. Clicking this button returns a request to confirm the operation. If the answer is Yes, query text will be specified for all databases. Confirmation is required if at least one driver other than the current one has non-empty query text.