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

Syarzhuk

Be healthy, stay wealthy...

Visit Belarusan Music Source - http://www.belmusic.net


_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com