BroadSQL Download
On this page
Documentation / Commands / SHOW SCRIPT VARIABLES

SHOW SCRIPT VARIABLES

Core command

Lists the SQL scripting variables of the session (set with LET or as Script arguments).

Syntax

SHOW SCRIPT VARIABLES

Examples

LET country = 'FR';
SHOW SCRIPT VARIABLES;

Example session

SHOW SCRIPT VARIABLES;
|--------|-------|----------|
|Name    |Type   |Value     |
|--------|-------|----------|
|country |VARCHAR|'FRA'     |
|max_id  |INTEGER|4090      |
|name    |VARCHAR|'O''Brien'|
|saved_id|INTEGER|4090      |
|--------|-------|----------|
Illustrative output: the values come from the WORLD sample and the practice connections of the how-to on QA and production copies of WORLD, and the layout from this release; it was not captured from a BroadSQL run, and your timings will differ.

Details

One row per variable, sorted by name: its name as last assigned, its type and its value. A string value is shown between single quotes, so the string 'NULL' is told apart from a NULL value, shown NULL. Without any variable, the command says so.

Only the variables set with LET or passed as Script arguments are listed, never the API variables set with VAR. The command works at the prompt and in Scripts, and its list is shown even under OUTPUT QUIET.

Last modified in release 5.5.0.

← All commands

Found something wrong or unclear on this page? , with the page address.