You might look into Eclipse (the java-based IDE). It has at least one ERD design plugin that allows graphical layout, editing of schema, and generation of DDL directly from the schema. It works with many DB platforms and is FREE!!! Sean On 6/1/06 5:44 AM, "dananrg@xxxxxxxxx" <dananrg@xxxxxxxxx> wrote: > Anyone know if DIA will generate CREATE TABLE statements from an ER > diagram? > > I'd like to have a program where I can create my db design, then be > able to instantiate the design in PostgreSQL as well as MySQL. > > I'll pay for a good commercial tool if it costs less than USD $100. > > Thanks. >