Help needed for COLUMN option in SCRIPT

[Sudeep C]

How can I use COLUMN option in SCRIPT.

I'm not able to figure this

java -classpath h2-1.4.199.jar org.h2.tools.Script -url "jdbc:h2:file:C:\test_db" -user sa -password "" -script "backup.sql" -options COLUMNS

Exception in thread "main" org.h2.jdbc.JdbcSQLSyntaxErrorException: Syntax error in SQL statement "SCRIPT  TO 'backup.sql'  COLUMNS[*]"; SQL statement:
SCRIPT  TO 'backup.sql'  COLUMNS [42000-199]

Please help me on this topic

[Evgenij Ryazanov]

Hello!

Unfortunately, this tool doesn't support all clauses of the SCRIPT command. You need to use the Shell tool or H2 Console or JDBC connection to the database.

Valid SQL command will be SCRIPT COLUMNS TO 'backup.sql'

https://h2database.com/html/commands.html#script

[Sudeep C]

Is there any other option to retrieve the INSERT statement with column names using the above tool?