Subject RE: [IBDI] Re: DEFAULT Values
Author Dmitry Yemanov
Hi Helen,

> Well, I don't see how changing the default would give the engine any clue
> as to what to do about existing values in the column. How would it know
> which rows which = the old default value were populated from the
> constraint and which were actual data?
> DEFAULT works only on inserts...

Maybe I wasn't clear enough. I was talking about inserts only. Existing
values should be kept as they are. I meant how I can change the DEFAULT
value to force the engine to use it in all subsequent inserts instead of the
old one. It is not allowed in IB by using ALTER TABLE ALTER COLUMN
statement. ALTER DOMAIN statement modifies RDB$FIELDS only and doesn't touch
RDB$RELATION_FIELDS, so I cannot use it for this purpose either.

The reason I'm asking this question is that the SQL92 spec defines a way to
set/drop DEFAULT value for any column.