--- In firebird-support@yahoogroups.com, "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.

Adam