Subject Re: DEFAULT Values
Author Syarzhuk Kazachenka
Helen Borrie wrote:
>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.
And it shouldn't

>How would it know which rows which = the old default value were
>populated from the constraint and which were actual data?
Doesn't matter, changing default value should only work for new inserts,
existing data should stay intact.

>DEFAULT works only on inserts...
And it should


Be healthy, stay wealthy...

Visit Belarusan Music Source -

Get your FREE download of MSN Explorer at