How to create table programming in version 2 ?

[Van Bruce]

hi,

I have a requirement for code to create tables dynamically, the code works fine in H2 version 1.x 

final Session session = connection.getSession();
final Database database = session.getDatabase();
final Schema schema = database.getSchema(session.getCurrentSchemaName());
final CreateTableData createTableData = new CreateTableData();
createTableData.schema = schema;
createTableData.tableName = tableName;
createTableData.id = database.allocateObjectId();
createTableData.temporary = false;
createTableData.globalTemporary = false;
createTableData.persistIndexes = false;
createTableData.persistData = false;
createTableData.create = true;
createTableData.session = session;

However in 2.x,  database cannot get directly from session.

Is there doc show how to solve or someone can help me 

thx in advance

[Noel Grandin]

You're using purely internal functions, which is always going to be problematic, because then you're never sure if you
have obeyed all the invariants which the code needs.

Why not just call "CREATE TABLE" using the normal JDBC API?

[Andreas Reichel]

Greetings.

As  Noel pointed out, for the H2 project this might be internal API subject to change without notification.

However, https://github.com/JSQLParser/JSqlParser and https://www.jooq.org/ provide such an API, which will De-Parse into a SQL, which can be executed in H2 (or any other RDBMS).

This way you would be independent from the particular SQL Flavour and/or RDBMS.

Cheers and good luck.

Andreas