|Subject||Re: [firebird-support] Re: default field value retrospective behaviour|
> > Furthermore, you can add a column with a NOT NULL constraint on itIMO, albeit caused by a user, Firebird should have some gbak switch
> > 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).
that makes your database restorable always, but raise warnings while
Being able to make your database unrestorable by a valid DDL statement
is kinda stupid.
Many database engines don't allowed "not null" columns to be added without
a "default clause" if there's data in the table. Perhaps Firebird can do the
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Database development questions? Check the forum!