Java: generate CREATE TABLE code from an existing table

is there a way to generate the CREATE TABLE code from an existing table i开发者_运维技巧n a Derby database? Or a simple way to gather the necessary table information?

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

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.

Well, this question is 6 years old, but here the screen shot below shows an easy way to do what you want. I hope you haven't been waiting. ;)

Right click on the table you're interested in and select Scripts -> Create TableScript.

When you choose this menu item, you will get a window containing SQL, e.g.

CREATE TABLE "JOOMP"."METRICLEVELS"
(
   LEVELID int NOT NULL,
   LEVELNAME varchar(30) NOT NULL
)
;

If you also want SQL that will populate the table with the existing data, use Scripts -> Create Data Script. For this example, you will get:

INSERT INTO "JOOMP"."METRICLEVELS" (LEVELID,LEVELNAME) VALUES (2,'Project');
INSERT INTO "JOOMP"."METRICLEVELS" (LEVELID,LEVELNAME) VALUES (3,'Package Fragment Root');
INSERT INTO "JOOMP"."METRICLEVELS" (LEVELID,LEVELNAME) VALUES (4,'Package Fragment');
INSERT INTO "JOOMP"."METRICLEVELS" (LEVELID,LEVELNAME) VALUES (5,'Compilation Unit');
INSERT INTO "JOOMP"."METRICLEVELS" (LEVELID,LEVELNAME) VALUES (7,'Type');
INSERT INTO "JOOMP"."METRICLEVELS" (LEVELID,LEVELNAME) VALUES (9,'Method');

I don't have any experience in using derby but you could try to use JDBC API to gather database metadata

This works fine in MySQL if you want the CREATE statement.

SHOW CREATE TABLE `table_name`

See mysql doc for more information