let's image that one creates an H2 database with table, indexes, etc... Is there an easy way to extract a SQL script to recreate the structure of this database in another H2 database?
I am not referring to the content of the tables, indexes, etc... I am just interested in the general structure of the database to replicate it elsewhere. Thanks.
I would use SCRIPT NODATA
(returns a result set) or SCRIPT NODATA TO 'fileName'
.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With