Subject Re: alter table question
Author Adam
>
> > I don't know by heart, if the existing fields are filled with the
> > default value.
>
> Only when you don't name them in a statement. In this all records are
> overwritten by the UPDATE statement.

I was under the impression that the default value was only ever
considered during an INSERT statement, and only if the field is not
explicitly named by the INSERT statement. In all other cases, it is
ignored.

Adam