Hi,

How is it possible to do an update script in firebird to upgrade a
database and add missing tables and fields?

I come from a sql server background and I can do it like this:


if not exists (SELECT * FROM SysObjects WHERE name = 'Tablename')
begin
create table Tablename(...)
end


if not exists (SELECT * FROM SysObjects WHERE name = 'Second_Tablename')
begin
create table Second_Tablename(...)
end

is there anything similar I can do with firebird?

Thanks

Giulio