Subject Re: Firebird SQL Support Adding columns
Author Adam
--- In, "lec_sas" <lec_sas@...> wrote:
> Does the Firebird SQL support adding new columns to a table after
> there is already data in the table?
> Thanks
> Darin Amos

google 'ALTER TABLE' for syntax.

Just be careful about adding a new column with a NOT NULL clause. If
you do this, you must be very sure to 'fill' the field in pre-existing
records, or your database backups will fail to restore without some
annoying work.

You must also be the sole transaction who is using that table to do it.