Using Client-Side Commands
You can use DbVisualizer these client-side command in your scripts.
Command | Description |
---|---|
@cd <directory> @run <file> [ <variables> ] | Use these command to execute an external script. |
@export | Use this command to export the result of a query or procedure call to a file. |
@delimiter <new_delimiter> | Use this command to temporarily change the statement delimiter for a complex statement. |
@call <function_or_proc> | Use this command to execute a function or procedure. |
@beep | Use this command to emit a been sound, e.g. to indicate a significant point in a script. |
@echo <text> | Use this command to write to the Log tab. |
@window iconify @window restore | Use these commands to lower (iconify) or raise (restore) the DbVisualizer main window. |
@desc <table> | Use this command to show column information for a table. The table name may be qualified with a schema and/or database name. |
@ddl <params> | Use this command to get the DDL for a database object. |
@spool log <file_name> | Use this command to write log messages to the named file. When executed in the SQL Commander, all log messages produced up to this point are written to the file; if Log to File is selected, this command is ignored. When executed by the pure command line interface, all log messages produced from this point onward are written to the file. |
@stop on error @stop on warning @continue on error<br></br>@continue on warning | Use these commands to control what to do when a statement results in a warning or an error. |
@set autocommit on @set autocommit off | Use these commands to control the Auto Commit state. |
@commit @rollback | Use these commands to explicitly commit or rollback updates. |
@set serveroutput on @set serveroutput off | Use these commands to enable or disable output to the DBMS Output tab. |
@set maxrows <number> @set maxchars <number> | Use these command to adjust the Max Rows and Max Chars limits for specific queries. |