db-ddlutils-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Philip Mark Donaghy <philip.dona...@gmail.com>
Subject Re: How do I obtain the ddl to dreate the database.
Date Fri, 20 Jan 2006 15:47:40 GMT
Thanks, that works.

On 1/20/06, Martin van den Bemt <mllist@mvdb.net> wrote:
> Just from a quick look at the code (I never used the tasks before) :
> alterDatbase should be set to false to get the full ddl in the file. doDrops should be
set to true
> or false depending on your needs.
> Afaik it will not do anything to your database.
>
> Mvgr,
> Martin
>
> Philip Mark Donaghy wrote:
> > 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
> >
> >
>


--
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

Mime
View raw message