Should the following:
ALTER TABLE TABLE1 ADD NEWFIELD INTEGER DEFAULT 0 NOT NULL;
always be followed by
UPDATE TABLE1 SET NEWFIELD=0;

Some tools (e.g. IBExpert) issue the seond cammand - others do not.
If the second is not issued (I seem to remember in older version of IB
anyway), this not null field remains NULL until the second command is
issued, lately I've noticed that it is zero - but this may be something to
do with the tols rendering the field

Any comments?
Alan