> Firebird 2,0 can do it. alter default and drop default statements for

this.

>
> Have a look release notes
> >
> > There's no ALTER TABLE to do that
>
> Really? :-)

That's good to know :-)



Either way, in Firebird < 2.0 it cannot be done easily ;)

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle &
MS SQL Server
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com