You can't is the short answer. IDENTITY columns and their underling SEQUENCEs are not guaranteed to always increase by one. For optimisation reasons, it may sometimes skip some numbers. If you really numbers increasing by one all the time you will have to implement it by hand.
-- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
