How do I obtain the ddl to dreate the database.

[Philip Mark Donaghy]

I am trying to obtain a file that has the create table statements.

I use ddlToDatabase in the following way,

    <createDatabase/>
    <writeSchemaToDatabase/>
    <writeSchemaSqlToFile outputFile="database.ddl"/>

I expected the create table statements to be in database.ddl but it
contains only the table alter statements.

ALTER TABLE "book"
    ADD CONSTRAINT "book_FK_author_id_author" FOREIGN KEY
("author_id") REFERENCES "author" ("author_id");

ALTER TABLE "book"
    DROP CONSTRAINT "book_FK_author_id_author";

Am I missing something?

--
Philip Donaghy
donaghy.blogspot.com del.icio.us/donaghy/philip
Skype: philipmarkdonaghy
Office: +33 5 56 60 88 02
Mobile: +33 6 20 83 22 62