AUTO-INC - TRIGGER Did you know another way to do it?

[Guest_imported]

Here the SQL for creating an AUTO-INC (increment id) trigger, enjoy it:

create generator gen_yourtable;

set term !!;
create trigger yourtable_bi for yourtable active before insert position 0 as
begin
if (new.id is null) then new.id=gen_id(gen_yourtable,1);
end !!
set term; !!