if not exists (select * from systable t join syscolumn c on t.table_id = c.table_id and
    LCase(table_name) = LCase('Hotels') and LCase(column_name) = LCase('IsActive')) then
alter table Hotels
  add IsActive integer default 1
end if;