Thanks a lot, Michaël
On 16 avr, 19:40, Thomas Mueller <[email protected]> wrote: > 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 > athttp://groups.google.com/group/h2-database?hl=en. -- 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.
