Java: generate CREATE TABLE code from an existing table

Question

is there a way to generate the CREATE TABLE code from an existing table in a Derby database? Or a simple way to gather the necessary table information?

Answer 1

You can try using the dblook tool to dump an Apache Derby database table into a sql file.

Answer 2

If you just want the CREATE-statement to recreate the table, this works for me:

CREATE TABLE new_table AS SELECT * FROM old_table WITH NO DATA;

But this does not help if you really want the CREATE-statement for some other purpose than creating a similar table.