You don't need a COLUMNS clause. It only changes insert statements from INSERT INTO TBL VALUES (1, 2, 3) to INSERT INTO TBL (A, B, C) VALUES (1, 2, 3), it can be useful if you want to load the script into some other database that don't support insert statements without names of columns.
I only need a script with all my database inserts. Unfortunately, H2 doesn't export such scripts. And I don't think that such script will be suitable for your use case, that was described here: https://groups.google.com/forum/#!topic/h2-database/1j9OAZpy5NA -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to h2-database+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/h2-database/5ea23b0d-2a3d-40c8-970f-12f3b18c82ca%40googlegroups.com.
