Hello Hans,

> After having created a Relation Column, was is the syntax to alter that
> Column to Default 0 ?
>
> For example.
>
> Alter Table Test add Saldo integer.
>
> then
>
> Alter Table Alter Saldo to Saldo type Integer Default 0, but that doesn't
> work

Firebird 2.1.3 release notes p. 39:

ALTER TABLE t ALTER [COLUMN] c SET DEFAULT default_value;
ALTER TABLE t ALTER [COLUMN] c DROP DEFAULT;



--
Best Regards,
Thomas Steinmaurer
LogManager Series - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database, MS SQL Server and
NexusDB V2
Upscene Productions
http://www.upscene.com
My blog:
http://blog.upscene.com/thomas/