Hi, If you didn't explicitly used a sequence, then I think what your are looking for is:
ALTER TABLE TEST ALTER COLUMN ID RESTART WITH 10000; See also http://h2database.com/html/grammar.html#alter_table_alter I wonder if other databases reset the identity if you truncate the table? Regards, Thomas -- 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.
