Hi,

> > I originally changed the length of a varchar field.
> > But in another db with the same metadata (i thought) and a tool.
> > I copied the command that this tool exceuted.
> > But in this db it was another field.
> > BTW is there a command for firebird to change the length of a
> > varchar field without hacking system tables ?
>
> I'm pretty critical against such tools, which are manipulating
> system tables without your knowledge directly. So, either
> use only pure DDL statements yourself, or give InterBase
> Workbench (http://www.interbaseworkbench.com) a try. Martijn
> Tonies (the author of InterBase Workbench) has always stated,
> that nothing magic is done behind the scenes. I'm pretty
> happy with it ...

Except for one thing :) ... Removing and adding a NOT NULL to
a column in a table...

The rest is pure DDL.

With regards,

Martijn Tonies
InterBase Workbench - the developer tool for InterBase and Firebird
http://www.interbaseworkbench.com

Upscene Productions
http://www.upscene.com

"This is an object-oriented system.
If we change anything, the users object."