wups, should've searched for that IDENT_CURRENT before.. Sorry, the method above gives you the NEXT value, not the CURRENT one.
I can only suggest select max.. On Jun 15, 2:29 pm, korwru <[email protected]> wrote: > How can I get the current number of ID (auto_increment) for a specific > table in the database? > > I'm looking for a query identical IDENT_CURRENT in database MS SQL. > > In JDBC a method getGeneratedKeys () returns the ID value, but only > after INSERT-query. -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.
