Hello, This is a minor feature request: Add support for the RESTART IDENTITY / CONTINUE IDENTITY options that can be passed to a TRUNCATE statement in some databases, specifically Postgres [1] and HSQLDB [2].
The H2 roadmap already features Postgres' CASCADE option, but I think IDENTITY handling might be easier to implement. In fact, RESTART IDENTITY could be a short-hand for executing two consecutive SQL statements: 1. The TRUNCATE statement 2. An ALTER TABLE [table] ALTER COLUMN [column] RESTART WITH [initial value] Cheers Lukas [1]: http://www.postgresql.org/docs/9.2/static/sql-truncate.html [2]: http://hsqldb.org/doc/guide/dataaccess-chapt.html#dac_truncate_statement -- 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?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
