The DBMS Command page is used to set a database, connection with which is used to execute the command, and a DMBS command text.
Set the parameters:
Select Database/Database. Select a database in the drop-down list of repository objects. The driver specified in settings of the selected database is highlighted with bold font and is set automatically when changing a database. The use of ClickHouse DBMS is available only in the web application.
To quickly select an object, enter object's name/identifier/key in the search box depending on display settings. Search is executed automatically while the searched text is entered into the search string. The list will display the objects, which names/identifiers/keys contain the entered text.
To set up displaying of repository objects, click the 
Show Object button and select display option in the drop-down menu:
Name. Objects are displayed with their names. Default option.
Identifier. Objects are displayed with their identifiers.
Key. Objects are displayed with their keys.
Several options can be selected. Identifier and key will be specified in brackets.
To reset selection for selected objects, click the 
Clear button.
Drivers/Driver. Select a driver type in the drop-down list. The driver highlighted with the bold font, which is used by the selected database, is displayed in the Driver list by default. If required, one can select another driver and determine the SQL query text for this driver. It is relevant if the repository will be used on servers with different DBMS and database settings in repository will be changed.
To show or hide the driver list, use the Hide Driver List/Show Driver List button.
Statement. Enter command text in the SQL language.
NOTE. When entering the command text, take into account differences of SQL language that may appear in different DBMS versions.
Apply for All DBMS. The button determines command text for all DBMS, that is, changing the driver does not affect command text. Clicking this button returns a request to confirm the operation. Confirmation is required if at least one driver differs from the current one, has non-empty query text.
See also: