Client Side Scripting
Table of contents
Overview
You can use special commands in the SQL scripts.
These commands are executed on DBeaver's side, not on the server-side.
Supported commands
DBeaver supports the following commands:
| Command | Database | Description |
|---|---|---|
@set var = value | All | Sets a script variable. You can use expressions as a value. Variables can be used as SQL queries input parameters. For more information see Dynamic parameter bindings |
@unset var | All | Unsets a script variable. |
@echo message | All | Prints message to output log. You can use a macro in a message (for example ${var}). |
@include fileName | All | - Executes a specified file name, - Can be used in scripts, - Opens a new SQL console with the specified file and processes SQL queries as in a regular SQL editor. |
@export { ... } | All | Opens the data transfer wizard with predefined settings. For more information see the main article. |
source fileName | MySQL | The same as @include but in MySQL CLI syntax. |
define var = value | Exasol | The same as @set but in Exasol EXAPlus syntax. |