Subject | Re: default field value retrospective behaviour |
---|---|
Author | Adam |
Post date | 2005-08-19T06:57:04Z |
Thanks Helen,
It would be nice then if the standard allowed some syntax to add the
field and update the values that already exist, except for the part of
me screaming not to mix ddl and dml.
Anyway, hopefully the ditz that wrote this table in the first place
(me) will learn not to forget about fields in the future.
Adam
> Furthermore, you can add a column with a NOT NULL constraint on itand
> and immediately make your database unrestorable if you don't go in >
> populate your existing rows.Ouch, (a good case for creating a backup before running any DDL script).
>
It would be nice then if the standard allowed some syntax to add the
field and update the values that already exist, except for the part of
me screaming not to mix ddl and dml.
Anyway, hopefully the ditz that wrote this table in the first place
(me) will learn not to forget about fields in the future.
Adam