firebird 字段自增

CREATE   GENERATOR   GEN_USERID;

CREATE   TRIGGER   "TRI_INS_ID "   FOR   "USER "  
ACTIVE   BEFORE   INSERT   POSITION   0
as
    begin
      NEW.ID=GEN_ID(GEN_USERID,1)
    end