Hi,
I will add the documentation in the next release:
-------------
== Special H2 Console Syntax ==
The H2 Console supports a few built-in commands. Those are interpreted
within the H2 Console, that means they work with any database. They
need to be at the beginning of a statement (before any remarks),
otherwise they are not parsed correctly. If in doubt, add ';' before
the command.
Command(s)
Description
@autocommit_true;
@autocommit_false;
Enable or disable autocommit.
@cancel;
Cancel the currently running statement.
@columns null null TEST;
@index_info null null TEST;
@tables;
@tables null null TEST;
Call the corresponding DatabaseMetaData.get method. Patterns are case
sensitive (usually identifiers are uppercase). For information about
the parameters, see the Javadoc documentation. Missing parameters at
the end are set to null. The complete list of commands is: @attributes
@best_row_identifier @catalogs @columns @column_privileges
@cross_references @exported_keys @imported_keys @index_info
@primary_keys @procedures @procedure_columns @schemas @super_tables
@super_types @tables @table_privileges @table_types @type_info @udts
@version_columns
@edit select * from test;
Use an updateable result set.
@generated insert into test() values();
Show the result of Statement.getGeneratedKeys().
@history;
Show the command history.
@info;
Display the result of various Connection and DatabaseMetaData methods.
@list select * from test;
Show the result set in list format (each column on its own line, with
row numbers).
@loop 1000 select ?, ?/*rnd*/;
@loop 1000 @statement select ?;
Run the statement this many times. Parameters (?) are set using a loop
from 0 up to x - 1. Random values are used for each ?/*rnd*/. A
Statement object is used instead of a PreparedStatement if @statement
is used. Result sets are read until ResultSet.next() returns false.
Timing information is printed.
@maxrows 20;
Set the maximum number of rows to display.
@meta select 1;
List the ResultSetMetaData after running the query.
@parameter_meta select ?;
Show the result of the PreparedStatement.getParameterMetaData() calls.
The statement is not executed.
@prof_start;
call hash('SHA256', '', 1000000);
@prof_stop;
Start / stop the built-in profiling tool. The top 3 stack traces of
the statement(s) between start and stop are listed (if there are 3).
@transaction_isolation;
@transaction_isolation 2;
Display (without parameters) or change (with parameters 1, 2, 4, 8)
the transaction isolation level.
-------------
Regards,
Thomas
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/h2-database?hl=en.
